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

132 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
gremlins113605(None) 
gremlin1035561gremlin_
kremlins1444481kremlins
cremains1238692cremains
drumlins1144992drumlins
graplins1148262graplins
gremmies1355992gremmies
kremlin1344212kremlin_
remains94117912_remains
berlins93216013_berlins
bromelins1346463bromelins
bromins112513783brom_ins
creatins103617513creatins
creeling113513363creeling
cremini11229063crem_ini
creminis12208253crem_inis
cretins93216423cre_tins
cymlins1436693_cymlins
drumlin1044423drumlin_
erepsins1037443erepsins
gamelans11115843gamelans
gamins94420053g_am_ins
gelling93219763g_elling
gemlike14206813g_emlike
gemming13289153g_emming
germans1079473germ_ans
germens1078633germ_ens
germina1038503germ_ina
germlike1535093germlike
gherkins1643993gherkins
goblins1039243g_oblins
gradins93416233gr_adins
grains74223093gr__ains
graplin1058443graplin_
grapline1138723grapline
graplines1237353graplines
gratins84119183gr_atins
grayling1338003grayling
graylings1433883graylings
greasing102811393greasing
greatens9307593greatens
greeing93613783gre_eing
greenies9312673greenies
greening103112533greening
greenings11266663greenings
greenling1136753greenling
greenlings1243593greenlings
greens75716873gre__ens
greeting103112353greeting
greetings11276043greetings
greisens954653greisens
gremial1039153grem_ial
gremials1136133gremials
gremmie1264383gremmi_e
greyhens1542633greyhens
greying124110893gre_ying
greylags1392313greylags
griffins1544783griffins
grilling103811533grilling
grimalkins1751473grimalkins
griming113612493grim_ing
grins65427223gr___ins
griskins1335953griskins
groins73917203gr__oins
growling1348163growling
grueling1078273grueling
gruelings1163763gruelings
gruelling1155603gruelling
gruellings1272323gruellings
grumbling1544083grumbling
grumping14266903grumping
gumline102810113g_umline
gumlines11238573g_umlines
haemins122811403haem_ins
hemins113417573_hem_ins
hemline12311073_hemline
hemlines13310623_hemlines
merlins93015813_merlins
myelins1237353mye_lins
prelims1139823pre_lims
premies113823063prem_ies
premiss113513813prem_iss
preplans1249613preplans
ratlins73615583_ratlins
reagins84215643_reagins
realigns936253_realigns
recline94020493_recline
reclines103718543_reclines
recoins94019243_recoins
redfins1139923_redfins
redline84218833_redline
redlines93916083_redlines
reeling83126863_reeling
reelings94012563_reelings
reflies104418533_reflies
regains84316583_regains
reins56234563_re__ins
rejoins143111383_rejoins
relics84517903_re_lics
relies65036423_re_lies
reline65434353_re_line
relines75331323_re_lines
relink104415923_re_link
relinks114510223_re_links
remails94714563_remails
remain85919863_remain_
remans84823003_rem_ans
remind94819793_rem_ind
reminds104614793_rem_inds
remint85329983_rem_int
remints95117293_rem_ints
remiss84216353_rem_iss
remits85622943_rem_its
renins64526453_re_nins
rennins74013413_rennins
repins84924313_re_pins
replans92814943_replans
replies94521043_replies
requins16310203_requins
resilins83013373_resilins
resins64528773_re_sins
retains74522253_retains
rewins95020823_re_wins
simlins9311843_simlins
theelins1137643theelins
tramline10311383tramline
tramlines1139843tramlines
trebling1139873trebling
trellis739873trelli_s
trembling1435193trembling
uremias9249503urem_ias
yeelins1038813_yeelins

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.423422437.4
2DLD Change Limit1461621326.51322441.6
3Display Results1321320.0502640.0
 (SQL Overall)1786911326.98625578.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.