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

91 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
drumlike154379(None) 
armlike1348552ar_mlike
dreamlike1642752dreamlike
drumfire1442542drumfire
drumlier1134522drumlier
drumlin1044422drumli_n
drumlins1144992drumlins
gumlike14317402_gumlike
plumlike1643792plumlike
ruglike1236282_ruglike
scumlike1644352scumlike
aguelike1344673aguelike
balmlike1655353balmlike
beamlike16115843beamlike
budlike14257873_budlike
clamlike1635163clamlike
clumplike1942603clumplike
cormlike1646703cormlike
crablike1636023crablike
crummie1336153crummi_e
cuplike1537213_cuplike
dawnlike1634673dawnlike
deerlike1335723deerlike
dirgelike1543213dirgelike
disclike15208653disclike
dishlike16287893dishlike
disklike12206743disklike
dislike122913453d_islike
doglike13207453d_oglike
domelike15177753domelike
doughlike1842683doughlike
dovelike16157133dovelike
downlike1636183downlike
dragline1036843dragline
druggie10134083druggi_e
drumble12337893drum_ble
drumbling1544033drumbling
drumfires1542553drumfires
drumfish1743503drumfish
drumliest1235433drumliest
drumly1235703druml__y
drumming14265783drumming
dualize1759763d_ualize
dunelike1335303dunelike
dustlike1335363dustlike
faunlike1534763faunlike
filmlike1734443filmlike
foamlike1735143foamlike
froglike1634363froglike
fruitlike1642853fruitlike
fumelike1735223_fumelike
gemlike14206813_gemlike
germlike1535093germlike
gluelike1335023gluelike
gumline102810113_gumline
gutlike12308653_gutlike
hutlike14349063_hutlike
ironlike1235713ironlike
jamlike20126923_jamlike
krumkake1241123krumkake
nunlike11258073_nunlike
nutlike113110113_nutlike
palmlike1656043palmlike
pumplike1834373_pumplike
puslike1347563_puslike
rampike1536603_rampike
ratlike113912353_ratlike
raylike14269253_raylike
riblike1337333_riblike
rodlike1288263_rodlike
rubylike1753353_rubylike
rufflike1843253_rufflike
runelike1236033_runelike
rushlike1534333_rushlike
seamlike14127183seamlike
shrublike1842713shrublike
soullike1236813soullike
souplike1436333souplike
stemlike1436723stemlike
sunlike112310573_sunlike
surflike1535933surflike
syruplike1842233syruplike
tramline10311383tramline
traplike1437653traplike
treelike1237003treelike
tublike1337083_tublike
turflike1534443turflike
unlike102614063__unlike
urnlike1136713ur_nlike
viruslike1642483viruslike
wormlike1735313wormlike

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 Filter1786911461620.423422437.4
2DLD Change Limit146162916.47022590.7
3Display Results91910.0461978.3
 (SQL Overall)178691916.93925751.7
 
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.