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

176 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
gillnet83973(None) 
gillnets934731gillnets
billet86029722bill_et
fillet95027082fill_et
gallet73630852gall_et
gallnut847252gallnut
giblet93418892gibl_et
giglet83920272gigl_et
gilled84521632gill_ed
giller74519732gill_er
gillie74816942gillie_
gillied95512312gillied
gillies84120962gillies
gimlet93716662giml_et
gullet74924832gull_et
millet84030742mill_et
rillet64828852rill_et
willet95124832will_et
aiglet74224193aigl_et
ailment9314233ailment
ballet84733973ball_et
ballonet10314503ballonet
billed94224903bill_ed
biller84923483bill_er
billets94516153bill_ets
billie85019173billie_
billies93923503billies
bullet84528613bull_et
callet84536763call_et
collet84030363coll_et
cullet84727313cull_et
dilled84122223dill_ed
dillies84122163dillies
diluent8310263diluent
dipnet91317473di_pnet
filet85540163fi_l_et
fille84327403fill_e_
filled104922263fill_ed
filler94623623fill_er
filles94224523fill_es
fillets103414753fill_ets
fillies103420253fillies
filmset1257513filmset
fishnet13410343fishnet
gallant83517113gallant
gallate83417123gallate
galled84622863gall_ed
galleta8399643gall_eta
gallets83517403gall_ets
galley104215453gall_ey
gallied94115003gallied
gallies84122713gallies
galliot82214133galliot
gallnuts943923gallnuts
galloot82814223galloot
gannet74321853g_annet
garnet73928413g_arnet
gelant72821673gelan_t
gellant83214053gellant
gelled84718893gell_ed
genet66038683g__enet
ghillie11326353ghillie_
ghillies12408663ghillies
giant65430593gi_an_t
gibbet114113383gi_bbet
giblets103210423gibl_ets
giglets93211553gigl_ets
giglot84013133gigl_ot
gilbert10310763gilbert
gilded94413223gi_lded
gilder84415533gi_lder
gill56336183gill___
gillers84216903gillers
gilling93520383gilling
gillnetted1251793gillnetted
gillnetter1151843gillnetter
gills64728193gill__s
gilly94321633gill__y
gilt56348543gi_l__t
gimlets10338433giml_ets
ginned83813983gi_nned
ginner73915823gi_nner
girlie73711463girlie_
girlier8289523girlier
girlies83013703girlies
girliest93010403girliest
girned84010513gi_rned
gleet65532343g__leet
glint66830183g_lin_t
goblet93219483gobl_et
goglet84618583gogl_et
grille74315743grill_e_
grilled94012833grill_ed
griller84513353grill_er
grilles83715023grill_es
guglet84018223gugl_et
guillemet1254243guillemet
gulled84521373gull_ed
gullets84013713gull_ets
gulley104213163gull_ey
gullied93812063gullied
gullies84717313gullies
gurnet74920873g_urnet
hilled104022223hill_ed
hiller94421633hill_er
hillier103413963hillier
hilliest113914113hilliest
hilloed113211293hilloed
hilloes103815963hilloes
iller54821293_ill_er
illest63615723_illest
illite63414923_illite
illness736473_illness
inlet53732403_inl_et
islet54527553_isl_et
killdee1266223killdee
killed113918773kill_ed
killer104917953kill_er
killie104114893killie_
killies113318113killies
kilned11368393ki_lned
linnet6419423li_nnet
lunet56835423__lunet
mallet84433053mall_et
mille75029133mill_e_
milled94326173mill_ed
miller84625413mill_er
milles84526563mill_es
millets94216843mill_ets
millier93716703millier
milline92519113milline_
milliner102811863milliner
millines102718063millines
milneb1095953mi_lneb
mullet84126823mull_et
nilled73919453nill_ed
pallet84232653pall_et
pellet83326553pell_et
piglet93420923pigl_et
pilled94222753pill_ed
pilsner935343pilsner
piolet83225643piol_et
planet84228353_planet
pullet84026333pull_et
quillet162713233quill_et
riblet84222443ribl_et
rille55728733rill_e_
rilled74525653rill_ed
rilles64725503rill_es
rillets74216153rill_ets
sallet63734543sall_et
signet73621153si_gnet
silane62718053silane_
silanes72517163silanes
silent64125843silen_t
siller64026063sill_er
sillier74017593sillier
sillies73425083sillies
silliest84017103silliest
skillet113512153skill_et
telnet6518833_telnet
tilled74722953till_ed
tiller64222543till_er
tillite7313563tillite
vilayet1348533vilayet
villae95615383villae_
violent102110813violent
violet92620923viol_et
wallet93327093wall_et
wiglet105519153wigl_et
willed104722453will_ed
willer94021063will_er
willets104414323will_ets
willie94116453willie_
willied114611563willied
willies103920153willies

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.390458182.1
2DLD Change Limit1340271766.76619808.9
3Display Results1761760.0632793.7
 (SQL Overall)1786911767.21924752.9
 
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.