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 “shallower” 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.

77 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
shallower155567(None) 
hallower14139811_hallower
sallower11139501s_allower
shallowed1655081shallowed
swallower1554331swallower
callower13159072_callower
hallowed15179492_hallowed
hallowers15137722_hallowers
hollower14127392_hollower
sallowed12149032s_allowed
scalloper1344452scalloper
shadower1544862sha_dower
shallow13388872shallow__
shallowest1643992shallowest
shallowly1842612shallowly
shallows14388862shallow_s
swallowed1663582swallowed
swallowers1653812swallowers
wallower14158932_wallower
allover1038583__allover
allowed111610083__allowed
balloter1078893_balloter
bellower13159063_bellower
fallowed15127753_fallowed
follower14137073_follower
galloper11137193_galloper
halloaed121510153_halloaed
halloed113314913_hallo_ed
halloes104021523_hallo_es
hallooed12168773_hallooed
hallow124818323_hallow__
hallows134417393_hallow_s
harrower1446363_harrower
hollowed15157023_hollowed
mellower13167403_mellower
safflower1842993safflower
sallier73320423s_all_ier
sallow94315753s_allow__
sallowest1246563s_allowest
sallowly14344833s_allowly
sallows103915553s_allow_s
sallowy13369343s_allow_y
scalloped1444463scalloped
scallopers1454043scallopers
shadowed1644473sha_dowed
shadowers1644303sha_dowers
shadowier1642893sha_dowier
shalier103116423sha_l_ier
shalloon1145683shallo_on
shalloons1245223shalloons
shallop12348453shallo__p
shallops13288323shallo_ps
shallot103614133shallo__t
shallots11319503shallo_ts
shallowing1744113shallowing
shallowness1752093shallowness
shampooer1643063shampooer
sheller103515893shell__er
shellier1138393shell_ier
shower124315113sh___ower
slalomer1045033sla_lomer
slower94016153s___lower
smaller93410333small__er
spaller92713473spall__er
spillover1442623spillover
starflower1672563starflower
sunflower1563553sunflower
swallow13355753swallow__
swallows14295893swallow_s
tallowed12157713_tallowed
unallowed1344413unallowed
unhallowed1742193unhallowed
walloper13147113_walloper
wallowed15148163_wallowed
wallowers15127653_wallowers
willower14127453_willower
yellower14186213_yellower

Search took 8 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 Filter1786911486410.420425454.8
2DLD Change Limit148641777.01621186.0
3Display Results77770.0332333.3
 (SQL Overall)178691777.46923924.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.