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

178 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
gurglets1035554(None) 
guglets9369691gu_glets
gurgles94312871gurgle_s
gurglet94412031gurglet_
burgles105615962burgle_s
gargets94614572garg_ets
garglers10418262garglers
gargles94214892gargle_s
giglets93211552g_iglets
goglets9379782g_oglets
gorgets94711782gorg_ets
guggles103410542guggle_s
guglet84018222gu_glet_
gullets84013712gu_llets
gurges84716862gurg_e_s
gurgle83912472gurgle__
gurgled10399122gurgle_d
gurnets84010792gur_nets
aglets73915683__aglets
aiglets84012913_aiglets
argles75218483_argle_s
armlets94610063_armlets
auklets11298573au_klets
budgets11489863budg_ets
buglers105115323bu_glers
bugles94822443bu_gle_s
bulblets1255353bulblets
bullets93516393bu_llets
bunglers11398483bunglers
bungles104116763bungle_s
burblers12399263burblers
burbles114916803burble_s
burets84321263bur__ets
burgees104915893burg_ees
burgers103918573burg_ers
burgess10409343burg_ess
burghers1435633burghers
burglars1154593burglars
burgle94815863burgle__
burgled115511423burgle_d
burgonets1243513burgonets
burgouts1145123burgouts
burlers94120273bur_lers
burleys12479673bur_leys
burnets93813263bur_nets
circlets1235663circlets
corslets1038273corslets
culets85518513cu__lets
cullets94015613cu_llets
curdlers11368493curdlers
curdles103814573curdle_s
cureless10319703cureless
curets84922343cur__ets
curlers94218073cur_lers
curlews12387393cur_lews
curvets12399913cur_vets
cutlets94113653cu_tlets
druggets11313913druggets
eaglets84111663_eaglets
forgets113813793forg_ets
froglets1235263froglets
fugles104715783fu_gle_s
furlers104214223fur_lers
furless103210143fur_less
gadgets10348683gadg_ets
gaggles103512593gaggle_s
gallets83517403g_allets
gantlets9308903gantlets
garblers113810283garblers
garbles104016923garble_s
garbless11388253garbless
garget84327273garg_et_
gargety12388043garg_ety
gargle84215463gargle__
gargled104210673gargle_d
gargler93710263gargle_r
garnets84115403gar_nets
garrets84413623gar_rets
gauntlets1042873gauntlets
giblets103210423g_iblets
gigglers11297403gigglers
giggles103312933giggle_s
giglet83920273g_iglet_
giglots9367863g_iglots
gimlets10338433g_imlets
girdlers10195403girdlers
girdles92210003girdle_s
goblets103210183g_oblets
gogglers11276713gogglers
goggles103510793goggle_s
goglet84618583g_oglet_
gorgers94813643gorg_ers
gorges85321893gorg_e_s
gorget87123863gorg_et_
gormless11235443gormless
gourmets1144153gour_mets
greets75117423g_r_eets
grivets11357973g_rivets
gruelers936173gruelers
grummets13275033grummets
guggle94110433guggle__
guggled11338563guggle_d
guiles73919283gu_ile_s
guilts74111233gu_il_ts
gules64831043gu__le_s
gullet74924833gu_llet_
gulleys11438523gu_lleys
gumless10228273gu_mless
gunless8299633gu_nless
gurge75419783gurg_e__
gurged95513363gurg_e_d
gurgling11267323gurgling
gurnet74920873gur_net_
gurneys11406463gur_neys
gurries83515953gurrie_s
gurshes112210033gurshe_s
gussets837443gu_ssets
gustless9287683gustless
gutless82610713gu_tless
guttlers9306933guttlers
guttles83011933guttle_s
guzzlers17274863guzzlers
guzzles16328043guzzle_s
harslets1137833harslets
hurdlers12337493hurdlers
hurdles113613373hurdle_s
hurlers103714323hur_lers
hurleys13407333hur_leys
hurtles103913753hurtle_s
hurtless11307783hurtless
jugglers17366523jugglers
juggles164510843juggle_s
jungles154112543jungle_s
juryless1832983juryless
kinglets13318583kinglets
martlets103310483martlets
mullets93614783mu_llets
murrelets11123243murrelets
nuggets936383nu_ggets
nutlets74111253nu_tlets
outlets73616363ou_tlets
pargets105215193parg_ets
partlets102811513partlets
piglets103311793_piglets
pullets94015163pu_llets
pungles104013713pungle_s
purflers13216963purflers
purfles122511843purfle_s
purgers104714003purg_ers
purges94421763purg_e_s
purples112712823purple_s
purplest12249123purplest
quillets17256823quillets
reglets83512983_reglets
relets64025673__relets
ringlets92910233ringlets
rundlets9307363rundlets
rungless956733rungless
runlets73310773ru_nlets
singlets93611473singlets
sniglets9276813sniglets
sublets92616703su_blets
surgers83517483surg_ers
surges73924593surg_e_s
targets84314223targ_ets
tartlets8289663tartlets
tugless837383tu_gless
turfless1135533turfless
turgites937783turgites
turrets73010673tur_rets
turtlers8258203turtlers
turtles72914343turtle_s
urgers73313623_urg_ers
urges64619913_urg_e_s
varlets10411573var_lets
wergelts1253413wergelts
wiglets113411423_wiglets
winglets12299593winglets

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.1561145455.1
2DLD Change Limit1461621787.26620115.9
3Display Results1781780.0602966.7
 (SQL Overall)1786911787.48223882.8
 
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.