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 “gremlin” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

122 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
gremlin103556(None) 
gremlins1136051gremlins
kremlin1344211kremlin
drumlin1044422drumlin
graplin1058442graplin
gremmie1264382gremmie
kremlins1444482kremlins
remain85919862_remain
berlin83116373_berlin
bromelin1246343bromelin
bromin102615693brom_in
creatin93618133creatin
creeling113513363creeling
cremains1238693cremains
cremini11229063crem_ini
cretin82917913cre_tin
cymlin1337313_cymlin
drumlins1144993drumlins
erepsin937383erepsin
gamelan10106643gamelan
gamin84423003g_am_in
gelid74916983g_e_lid
gelling93219763g_elling
gemlike14206813g_emlike
gemming13289153g_emming
german9611983germ_an
germen9612313germ_en
germina1038503germ_ina
germlike1535093germlike
gherkin1544043gherkin
goblin939503g_oblin
gradin83517483gr_adin
grain65126253gr__ain
grapline1138723grapline
graplins1148263graplins
gratin74520583gr_atin
grayling1338003grayling
greasing102811393greasing
greaten83610643greaten
greeing93613783gre_eing
green65522143gre__en
greenie8310123greenie
greening103112533greening
greenling1136753greenling
greenlit945803greenlit
greeting103112353greeting
greisen856503greisen
gremial1039153gremial
gremmies1355993gremmies
gremmy1454473grem_my
greyhen1443193greyhen
greying124110893gre_ying
greylag1262553greylag
greyly13316543greyl_y
griffin1434513griffin
grilling103811533grilling
grimalkin1651543grimalkin
grimily1336523grimily
griming113612493grim_ing
grimly12459933griml_y
grin55733723gr___in
griskin1236013griskin
groin65521083gr__oin
growling1348163growling
grueling1078273grueling
gruelling1155603gruelling
grumbling1544083grumbling
grumping14266903grumping
gumline102810113g_umline
haemin113412663haem_in
hemin103620933_hem_in
hemline12311073_hemline
merlin83916683_merlin
myelin1138973mye_lin
prelim10311423pre_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 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271226.48620664.0
3Display Results1221220.0462652.2
 (SQL Overall)1786911226.93825755.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.