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

152 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
gillnets93473(None) 
gillnet839731gillnet_
billets94516152bill_ets
fillets103414752fill_ets
gallets83517402gall_ets
gallnuts943922gallnuts
giblets103210422gibl_ets
giglets93211552gigl_ets
gillers84216902gill_ers
gillies84120962gillie_s
gimlets10338432giml_ets
gullets84013712gull_ets
illness736472_illness
millets94216842mill_ets
rillets74216152rill_ets
willets104414322will_ets
agileness1046493agileness
aiglets84012913aigl_ets
ailments1039433ailments
ballets93719513ball_ets
ballonets1146723ballonets
billers94720833bill_ers
billet86029723bill_et_
billies93923503billie_s
bullets93516393bull_ets
callets93821703call_ets
chillness1455373chillness
collets93517903coll_ets
cullets94015613cull_ets
dillies84122163dillie_s
diluents946053diluents
dipnets10109033di_pnets
dullness934873dullness
fellness1135913fellness
filets94718953fi_l_ets
fillers104320213fill_ers
filles94224523fill_e_s
fillet95027083fill_et_
fillies103420253fillie_s
filmsets1353413filmsets
fishnets1445633fishnets
fullness1135443fullness
gallants93310373gallants
gallates92815523gallates
gallet73630853gall_et_
galleta8399643gall_eta
galletas9308133gall_etas
galleys11369713gall_eys
gallies84122713gallie_s
galliots9228683galliots
gallnut847253gallnut_
galloots9268963galloots
gannets83811443g_annets
garnets84115403g_arnets
gelants82611443gelan_ts
gellants9308283gellants
genets75716663g__enets
ghillies12408663ghillie_s
giants74713503gi_an_ts
gibbets12417723gi_bbets
giblet93418893gibl_et_
giglet83920273gigl_et_
giglots9367863gigl_ots
gilberts1134183gilberts
gilders94212463gi_lders
gilled84521633gill_e_d
giller74519733gill_e_r
gillie74816943gillie__
gillied95512313gillie_d
gillnetted1251793gillnetted
gillnetter1151843gillnetter
gillnetters1261453gillnetters
gills64728193gill___s
gilts64924263gi_l__ts
gimlet93716663giml_et_
ginners84314223gi_nners
girlies83013703girlie_s
girliest93010403girliest
gleets75315053g__leets
glibness1134133glibness
glints75714213g_lin_ts
goblets103210183gobl_ets
goglets9379783gogl_ets
grillers93810813grill_ers
grilles83715023grill_e_s
guglets9369693gugl_ets
guillemets1362273guillemets
gullet74924833gull_et_
gulleys11438523gull_eys
gullies84717313gullie_s
gurnets84010793g_urnets
hillers103718733hill_ers
hilliest113914113hilliest
hilliness1248923hilliness
hilloes103815963hilloe_s
illest63615723_ill_est
illites72415013_illites
inlets63915573_inl_ets
islets64513083_isl_ets
killdees1373963killdees
killers114215583kill_ers
killies113318113killie_s
linnets739833li_nnets
lunets66914763__lunets
mallets93318493mall_ets
mildness1136523mildness
millers93621343mill_ers
milles84526563mill_e_s
millet84030743mill_et_
milliers102611903milliers
milliners11289953milliners
millines102718063milline_s
milnebs11113793mi_lnebs
mullets93614783mull_ets
oiliness8311563oiliness
pallets93919303pall_ets
pellets94014783pell_ets
piglets103311793pigl_ets
pilsners1035533pilsners
piolets93513193piol_ets
planets93914083_planets
pullets94015163pull_ets
quillets17256823quill_ets
riblets93412553ribl_ets
rilles64725503rill_e_s
rillet64828853rill_et_
sallets73719653sall_ets
signets83311503si_gnets
silanes72517163silane_s
silents73514493silen_ts
sillers73822103sill_ers
sillies73425083sillie_s
silliest84017103silliest
silliness9510363silliness
skillets12226823skill_ets
solonets838233solonets
stillness936103stillness
tallness837103tallness
telnets738373_telnets
tillers73418743till_ers
tillites8312833tillites
vilayets1443073vilayets
vileness1139983vileness
violets102210003viol_ets
wallets103914833wall_ets
wellness1135793wellness
wiglets113411423wigl_ets
wildness1236203wildness
wiliness1139113wiliness
willers103517913will_ers
willet95124833will_et_
willies103920153willie_s

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 Limit1461621526.21623513.8
3Display Results1521520.0632412.7
 (SQL Overall)1786911526.70226662.3
 
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.