Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “stranglers” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

93 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
stranglers1139682(None) 
stragglers12305251stragglers
strangers104112161strang_ers
strangler10369471strangler_
strangles103011551strangle_s
estrangers11376102estrang_ers
straddlers12203822straddlers
straggler11377292straggler_
straggles11328502straggle_s
stranders10389932stran_ders
stranger94715102strang_er_
stranges94516762strang_e_s
strangle98411502strangle__
strangled11268982strangle_d
stringers104210642string_ers
stringless1145352stringless
strugglers12273062strugglers
tanglers92911972_t_anglers
twanglers1363432_twanglers
wranglers1344272_wranglers
anglers84014823___anglers
arrangers1045823arrang_ers
danglers103610593__danglers
derangers1136703derang_ers
entanglers1163033entanglers
estranger10447843estrang_er_
estranges10359983estrang_e_s
grangers103011973_grang_ers
haranguers1442473haranguers
janglers16319373__janglers
manglers113311903__manglers
rangers83621043__rang_ers
sangers84421943s__ang_ers
scrabblers16213813scrabblers
scramblers16183543scramblers
scrawlers1434753scra_wlers
shinglers13246443s_hinglers
spangles1138893s_pangle_s
sprawlers1433903spra_wlers
springers12309983spring_ers
springlets1344023springlets
sprinklers1642973sprinklers
stablers103611153st_a_blers
stagers84116673st_a_g_ers
staggers10379843st_a_ggers
stanchers14206813st_anchers
standers93514303st_an_ders
staplers103111203st_a_plers
startlers9236743st_artlers
stealers83412203stea__lers
stingers94012743st_ing_ers
stingless1046463st_ingless
straddler11205113straddler_
straddles11216403straddle_s
strafers11379913stra__fers
straggle10359133straggle__
straggled12296853straggle_d
stragglier1243503stragglier_
strainers9510383stra_iners
strander97112063stran_der_
strange85416343strang_e__
strangely1345413strang_ely
strangeness1246093strangeness
strangered1245413strang_ered
strangest103210843strang_est
strangling1256403strangling
strangury1343203strang_ury
strapless1135793stra_pless
strappers1346743stra_ppers
strayers113510143stra__yers
stringer93812943string_er_
stringier1036713stringier_
strollers937543str_ollers
stronger9349693strong_er_
strongyles1443233strongyle_s
struggler11264553struggler_
struggles11255283struggle_s
tangler83515073_t_angler_
tangles83920043_t_angle_s
tinglers93710593_t_inglers
trailers82912923_tra_ilers
tramplers13305883_tramplers
transfers1238053_transfers
travelers12266773_travelers
trawlers113310203_tra_wlers
triangles1035743_triangle_s
trundlers10215003_trundlers
twangers12226063_twang_ers
twangler1244113_twangler_
twangles1245743_twangle_s
wanglers123310033__wanglers
wrangler1245473_wrangler_
wrangles1237463_wrangle_s

Search took 7 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911406030.406440125.6
2DLD Change Limit140603936.34622156.2
3Display Results93930.0432162.8
 (SQL Overall)178691936.79526297.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.