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

258 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
gigglers1129740(None) 
giggler101029881giggler_
giggles103312931giggle_s
gogglers11276711gogglers
higglers13297231higglers
nigglers10307251nigglers
wigglers13257211wigglers
bogglers12347602bogglers
diggers104413392digg_ers
gaggers103413662gagg_ers
gaggles103512592gaggle_s
garglers10418262garglers
giggle94313512giggle__
giggled114010072giggle_d
gigglier1154322gigglier_
giglets93211552gi_glets
gillers84216902gi_llers
gingers94118642ging_ers
girdlers10195402girdlers
goggler10379322goggler_
goggles103510792goggle_s
guggles103410542guggle_s
hagglers13326622hagglers
higgler12369802higgler_
higgles123911802higgle_s
jiggers164010182jigg_ers
jiggles164111432jiggle_s
jinglers16408762jinglers
jogglers17356882jogglers
jugglers17366522jugglers
miggles113512032miggle_s
minglers113011292minglers
niggers93111322nigg_ers
niggler93610292niggler_
niggles93512202niggle_s
riggers93613842rigg_ers
snigglers11314592snigglers
tinglers93710592tinglers
togglers10276952togglers
wiggler123110762wiggler_
wiggles123312462wiggle_s
wrigglers14273712wrigglers
aggers85817793_agg_ers
aiglets84012913ai_glets
anglers84014823_anglers
baggers113915693bagg_ers
bigger104315063bigg_er_
biggies113813523biggie_s
billers94720833bi_llers
bingers104519993bing_ers
birlers93813003bi_rlers
boggler113910083boggler_
boggles113411823boggle_s
buggers114315663bugg_ers
buglers105115323_buglers
bunglers11398483bunglers
chiggers1535563chigg_ers
circlers1235353circlers
daggers103714913dagg_ers
daggles103611913daggle_s
danglers103610593danglers
dialers83614303di_alers
diallers957773diallers
dibblers13377583dibblers
diddlers11359153diddlers
digger94616083digg_er_
dingers94321383ding_ers
dingles93818323dingle_s
doggers104413433dogg_ers
eggers84612583_egg_ers
eggless935663_eggless
fiddlers13328283fiddlers
fighters15269403fighters
figurers12254873figurers
filers94623723fi__lers
fillers104320213fi_llers
finaglers13173893finaglers
fingers113418433fing_ers
foggers124112013fogg_ers
gabblers134110083gabblers
gagers84021333g_ag_ers
gagger95016513gagg_er_
gaggle93412623gaggle__
gaggled11359913gaggle_d
gagsters10317083gagsters
gamblers13369733gamblers
gangers94418603gang_ers
gaolers83511563g_aolers
garblers113810283garblers
gargler93710263gargler_
gargles94214893gargle_s
gaugers94211713gaug_ers
gibbers124710983gi_bbers
gibers95114663gi__bers
giblets103210423gi_blets
giftless1245173giftless
gigged104112293gigg_e_d
giggliest1234323giggliest
giggling10227043giggling
giggly12518703giggl__y
giglet83920273gi_gle_t
giglots9367863gi_glots
gigolos934693gigol_os
gigues8129003gi_gue_s
gilders94212463gi_lders
giller74519733gi_ller_
gimlets10338433gi_mlets
gingeleys14272893gingeleys
gingelis10247093gingelis
ginger84920033ging_er_
gingery12368913ging_ery
ginners84314223gi_nners
gippers123212083gi_ppers
girders9379943gi_rders
girdler9227313girdler_
girdles92210003girdle_s
givers104817713gi__vers
gobblers13308343gobblers
goggle94511573goggle__
goggled11348953goggle_d
gogglier1153923gogglier_
goglets9379783g_oglets
gorgers94813643gorg_ers
gougers94911763goug_ers
grillers93810813grillers
grizzlers18253233grizzlers
growlers12327093growlers
gruelers936173gruelers
guggle94110433guggle__
guggled11338563guggle_d
guglets9369693g_uglets
gurgles94312873gurgle_s
gurglets10355543gurglets
guttlers9306933guttlers
guzzlers17274863guzzlers
haggler12328933haggler_
haggles123312483haggle_s
higgle113811743higgle__
higgled13339073higgle_d
hillers103718733hi_llers
hingers113420213hing_ers
hoggers124512483hogg_ers
huggers124211593hugg_ers
idlers74012813_i_dlers
ingles74420873_ingle_s
jaggers164012893jagg_ers
janglers16319373janglers
jigger155313053jigg_er_
jiggier16377823jiggier_
jiggle153811993jiggle__
jiggled17358843jiggle_d
jigglier1754093jigglier_
jingler154311093jingler_
jingles153816383jingle_s
joggers164110693jogg_ers
joggler16398833joggler_
joggles164410413joggle_s
juggler16418873juggler_
jugglery20303813jugglery
juggles164510843juggle_s
kegelers1355163kegelers
keggers13357043kegg_ers
keglers12277773_keglers
killers114215583ki_llers
kindlers13318483kindlers
kingless13288693kingless
kinglets13318583kinglets
laggers94216243lagg_ers
libelers10238623libelers
ligers75022043li_g_ers
lighters123111393lighters
ligules82210923ligule_s
lingers84223303ling_ers
loggers94616133logg_ers
luggers93713483lugg_ers
manglers113311903manglers
middlers123410193middlers
miggle104012113miggle__
milers84625163mi__lers
millers93621343mi_llers
mingler104213843mingler_
mingles103719003mingle_s
muggers113611933mugg_ers
naggers93812653nagg_ers
nibblers12306543nibblers
nigger89713573nigg_er_
niggle83612823niggle__
niggled10319203niggle_d
nigglier1044843nigglier_
oglers74313183__oglers
oilers64721193oi__lers
piddlers12359593piddlers
piggery14266193pigg_ery
piggier113510003piggier_
piggies113813483piggie_s
piglets103311793pi_glets
pingers104020743ping_ers
raggles93813283raggle_s
regalers94311133regalers
riddlers10269103riddlers
rifflers14336443rifflers
riflers103512193ri_flers
rigger85616713rigg_er_
righters122610713righters
ringers83922953ring_ers
ringlets92910233ringlets
ripplers12337113ripplers
ruggers94612313rugg_ers
saggers94017083sagg_ers
shinglers13246443shinglers
sidlers83414233si_dlers
sighers113712183si_ghers
sighless1276553sighless
sighters122510603sighters
signalers1044583signalers
signers84714443si_gners
sillers73822103si_llers
singers83824703sing_ers
singles83520433single_s
singlets93611473singlets
sizzlers16274753sizzlers
smugglers13263433smugglers
sniggers10317093snigg_ers
sniggler10396113sniggler_
sniggles10307313sniggle_s
swiggers13337123swigg_ers
taggers93514193tagg_ers
tanglers92911973tanglers
ticklers14339303ticklers
tiddlers10288653tiddlers
tigers75616513ti_g_ers
tilers63523503ti__lers
tillers73418743ti_llers
tingler83613343tingler_
tingles83818323tingle_s
tinklers12298183tinklers
tipplers12336353tipplers
toggler9399193toggler_
toggles93710973toggle_s
triggers10257843trigg_ers
tuggers93711443tugg_ers
waggers124613083wagg_ers
waggles123812003waggle_s
wanglers123310033wanglers
wiggery15295873wigg_ery
wiggier12418863wiggier_
wiggle113713013wiggle__
wiggled13299603wiggle_d
wigglier1354453wigglier_
wigless11359673wi_gless
wiglets113411423wi_glets
willers103517913wi_llers
wingers113921483wing_ers
wingless122910023wingless
winglets12299593winglets
wriggler13295263wriggler_
wriggles13286263wriggle_s
zingers173514853zing_ers

Search took 9 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.420425454.8
2DLD Change Limit1461622587.65619091.2
3Display Results2582580.1102345.5
 (SQL Overall)1786912588.18621828.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.