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

85 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
kremlin134421(None) 
gremlin1035561gremlin
kremlins1444481kremlins
drumlin1044422drumlin
gremlins1136052gremlins
remain85919862_remain
berlin83116373_berlin
bromelin1246343bromelin
bromin102615693brom_in
creatin93618133creatin
creeling113513363creeling
cremains1238693cremains
cremini11229063crem_ini
cretin82917913cre_tin
cymlin1337313_cymlin
drumlins1144993drumlins
erepsin937393erepsin
graplin1058443graplin
gremmie1264383gremmie
haemin113412663haem_in
hemin103620933_hem_in
hemline12311073_hemline
kamsin1238323k_amsin
kaolin1039583k_aolin
keeling123515123k_eeling
kegling13309363k_egling
kelim11912553k_e_lim
kelvin13117323k_elvin
keratin113314153keratin
kermis124012403kerm_is
khamsin1643983khamsin
kneeling13287783kneeling
knelling13319023knelling
kraaling13186663kraaling
kvelling16146513kvelling
merlin83916683_merlin
myelin1138973mye_lin
prelim10311433pre_lim
preman104117453prem_an
premen105017803prem_en
premie103617993prem_ie
premix173710333prem_ix
preplan1149953preplan
ratlin64116523_ratlin
reagin74915533_reagin
realia6314593_realia
realign838763_realign
recline94020493_recline
recoin84320293_recoin
redfin10310223_redfin
redline84218833_redline
reeling83126863_reeling
regain74517763_regain
rein46040893_re__in
rejoin134012243_rejoin
relic74623363_re_lic
reline65434353_re_line
relink104415923_re_link
relit55340683_re_lit
remail85017123_remail
remains94117913_remains
reman75730153_rem_an
remind94819793_rem_ind
remint85329983_rem_int
remit75737223_rem_it
remix145916553_rem_ix
renin54830033_re_nin
rennin63914033_rennin
repin75324703_re_pin
replan83215823_replan
requin15310713_requin
resilin72913973_resilin
resin54131053_re_sin
retain64523283_retain
rewin85623963_re_win
simlin8311733_simlin
theelin1038003theelin
tramline10311383tramline
trebling1139873trebling
trellis739873trellis
trembling1435193trembling
uremia82910893urem_ia
uremic103410513urem_ic
vermin113414523verm_in
yeelin939343_yeelin

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 Filter1786911340270.406440125.6
2DLD Change Limit134027856.72019944.5
3Display Results85850.0302833.3
 (SQL Overall)178691857.15624970.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.