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

97 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
drumlins114499(None) 
drumlin1044421drumlin_
drumbling1544032drumbling
drumlier1134522drumlier
drumliest1235432drumliest
drumlike1543792drumlike
drumming14265782drumming
dunlins849552d_unlins
gremlins1136042gremlins
kremlins1444482kremlins
alumins9512983alum_ins
bromelins1346453bromelins
bromins112513783brom_ins
brucins1158003bru_cins
bruins86014953bru__ins
brumbies1436533brumbies
bumkins15318013_bumkins
cremains1238693cremains
crumbing15267813crumbing
crumbling1655083crumbling
crumblings1742513crumblings
crummies1437643crummies
crumping15319903crumping
crumpling1645323crumpling
cumins103314933_cum_ins
cummins1358963_cummins
cymlins1436693_cymlins
dauphins1444523dauphins
diamins10312213diam_ins
domains10510873d_omains
dormins10311273dorm_ins
doubling1238153doubling
dragline1036843dragline
draglines1145993draglines
drains73719403dr__ains
dramming14347563dramming
drawling13318673drawling
drilling103311983drilling
drillings11285823drillings
drolling103510763drolling
dromons1038193drom_ons
drooling102610423drooling
drubbing14286053drubbing
drubbings15262883drubbings
drudging12256233drudging
druggies11126223druggies
drugging12326443drugging
druids8368093dru__ids
drumbles13277723drumbles
drumfire1442543drumfire
drumfires1542553drumfires
drumfish1743503drumfish
drumly1235703druml__y
drummers13316163drummers
drums85415873drum___s
dubbins12358803d_ubbins
dueling93614543d_ueling
dulias71212743d_u_lias
dulling93418273d_ulling
dumbing13319853d_umbing
dummies123012133d_ummies
dumping133712913d_umping
dumpings14295763d_umpings
dumpling14217893d_umpling
dumplings15213853d_umplings
dunlin739723d_unlin_
duumvirs1441223duumvirs
graplins1148263graplins
gremlin1035563gremlin_
grueling1078273grueling
gruelings1163763gruelings
grumbling1544083grumbling
grumping14266903grumping
gumline102810113_gumline
gumlines11238573_gumlines
inulins7311493inu_lins
kremlin1344213kremlin_
moulins9312703mou_lins
muslins9312213_muslins
paulins9312613pau_lins
purlins93415423_purlins
ratlins73615583_ratlins
remains94117903_remains
ruins55822033_ru__ins
ruling73219553_ru_ling
rulings83310383_ru_lings
rumbling131910103_rumbling
rumblings14184633_rumblings
rumens83611813_rum_ens
rumina83412483_rum_ina
rummies113212793_rummies
rumpling13178763_rumpling
rutins63818393_ru_tins
simlins9311843_simlins
tramline10311383tramline
tramlines1139843tramlines
trumping13308733trumping

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 Filter1786911461620.1561145455.1
2DLD Change Limit146162977.51619446.8
3Display Results97970.0303233.3
 (SQL Overall)178691977.70223200.6
 
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.