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

412 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
wiggler12311076(None) 
giggler101029881giggler
higgler12369801higgler
niggler93610291niggler
wiggier12418861wiggier
wiggle113713011wiggle_
wiggled13299601wiggled
wigglers13257201wigglers
wiggles123312461wiggles
wigglier1354451wigglier
wriggler13295261wriggler
bigger104315062bigg_er
boggler113910082boggler
digger94616082digg_er
giggle94313512giggle_
giggled114010072giggled
gigglers11297392gigglers
giggles103312932giggles
gigglier1154322gigglier
goggler10379322goggler
haggler12328932haggler
higgle113811742higgle_
higgled13339072higgled
higglers13297222higglers
higgles123911802higgles
jigger155313052jigg_er
jiggier16377822jiggier
jiggle153811992jiggle_
jiggled17358842jiggled
jiggles164111432jiggles
jigglier1754092jigglier
jingler154311092jingler
joggler16398832joggler
juggler16418872juggler
miggle104012112miggle_
miggles113512032miggles
mingler104213842mingler
nigger89713572nigg_er
niggle83612822niggle_
niggled10319202niggled
nigglers10307242nigglers
niggles93512202niggles
nigglier1044842nigglier
piggier113510002piggier
rigger85616712rigg_er
sniggler10396112sniggler
swigger12338452swigg_er
tingler83613332tingler
toggler9399192toggler
twiggier1333072twiggier
wagger113616012wagg_er
waggle113612302waggle_
waggled13389362waggled
waggles123812002waggles
wagglier1344322wagglier
wangler113312652wangler
wigged124413582wigg_ed
wiggery15295872wigg_ery
wiggly14559682wiggl_y
wiglet105519152wi_glet
willer94021062wi_ller
winger104125442wing_er
wingier113413282wingier
winglet113115982winglet
wriggle12316212wriggle_
wriggled14284662wriggled
wrigglers14273712wrigglers
wriggles13286262wriggles
wrigglier1462412wrigglier
agger76420893_agg_er
aiglet74224193ai_glet
angler74017863_angler
bagger104619203bagg_er
baggier113611643baggier
biggie103810933biggie_
biggies113813523biggies
bilgier10358533bilgier
biller84923483bi_ller
binger94923453bing_er
birler85715083bi_rler
boggier113711583boggier
boggle104511943boggle_
boggled12409003boggled
bogglers12347603bogglers
boggles113411823boggles
bugger104418723bugg_er
buggier113611343buggier
bugler94717723_bugler
bungler104611483bungler
chigger1436003chigg_er
circler1136423circler
dagger95017303dagg_er
daggle93711903daggle_
daggled11329463daggled
daggles103611913daggles
dangler96912813dangler
dialer74315433di_aler
dialler848813dialler
dibbler124510283dibbler
diddler103511513diddler
digged104314653digg_ed
diggers104413383digg_ers
dinger85323673ding_er
dingier93513673dingier
dingle84317073dingle_
dingles93818323dingles
dogger95216783dogg_er
doggier103810943doggier
egger74414403_egg_er
faggier12309843faggier
fickler16348423fickler
fiddler12309953fiddler
figged124013893figg_ed
fighter143010763fighter
figurer11215853figurer
filer85433003fi__ler
filler94623623fi_ller
finagler12194953finagler
finger104920333fing_er
fogger114414783fogg_er
foggier12349913foggier
fuggier12348963fuggier
gagger95016513gagg_er
gaggle93412623gaggle_
gaggled11359913gaggled
gaggles103512593gaggles
gargler93710263gargler
gigged104112293gigg_ed
giggly12518703giggl_y
giglet83920273gi_glet
giller74519733gi_ller
ginger84920033ging_er
girdler9227313girdler
goggle94511573goggle_
goggled11348953goggled
gogglers11276713gogglers
goggles103510793goggles
gogglier1153923gogglier
guggle94110433guggle_
guggled11338563guggled
guggles103410543guggles
haggle113511983haggle_
haggled13359283haggled
hagglers13326623hagglers
haggles123312483haggles
higher134610893hi_gher
hiller94421633hi_ller
hinger104723323hing_er
hogger114615083hogg_er
hugger114713123hugg_er
idler65015663_i_dler
igged86012763_igg_ed
iller54821293_i_ller
ingle64120433_ingle_
ingles74420873_ingles
jagger154016003jagg_er
jaggier16339183jaggier
jangler153811833jangler
jigged164412773jigg_ed
jiggers164010173jigg_ers
jiggly18378713jiggl_y
jingle143815223jingle_
jingled164111063jingled
jinglers16408763jinglers
jingles153816383jingles
jinglier1655233jinglier
jogger154713163jogg_er
joggle154010353joggle_
joggled17398433joggled
jogglers17356883jogglers
joggles164410413joggles
juggle154310283juggle_
juggled17348653juggled
jugglers17366523jugglers
jugglery20303813jugglery
juggles164510843juggles
kegeler1245493kegeler
kegger12388063kegg_er
kegler11398233_kegler
killer104917953ki_ller
kindler12309983kindler
kinglet123114043kinglet
kinglier1345633kinglier
kittler11338163kittler
lagger85919833lagg_er
leggier9368233leggier
libeler9219003libeler
liger65024473li_g_er
lighter113113433lighter
ligular8348533ligular
ligule74010833ligule_
ligules82210913ligules
linger75226003ling_er
lingier84113383lingier
littler7348553littler
logger86420003logg_er
loggier93811143loggier
lugger83916553lugg_er
mangler103215643mangler
mickler153310233mickler
middler112712273middler
miler75733063mi__ler
miller84625413mi_ller
mingier103815293mingier
mingle93518783mingle_
mingled113612733mingled
minglers113011293minglers
mingles103719003mingles
mugger103914703mugg_er
muggier11288943muggier
nagger84016123nagg_er
naggier9309153naggier
nibbler11379273nibbler
niggers93111313nigg_ers
niggly11418913niggl_y
nigher103612753ni_gher
nimbler11358063nimbler
ogler65917443__ogler
oiler54628283oi__ler
piddler112911523piddler
pigged114214153pigg_ed
piggery14266193pigg_ery
piggie103210773piggie_
piggies113813483piggies
piglet93420923pi_glet
pinger94324093ping_er
puggier11309383puggier
raggle83712883raggle_
raggles93813283raggles
regaler83814623regaler
riddler93411263riddler
ridgier937883ridgier
riffler13328353riffler
rifler94014263ri_fler
rigged94517403rigg_ed
riggers93613833rigg_ers
righter113212373righter
ringer74526063ring_er
ringlet82818173ringlet
rippler113210103rippler
rugger84414513rugg_er
sagger84321073sagg_er
saggier92912063saggier
shingler12268623shingler
sidler74716963si_dler
sigher103813703si_gher
sighter113412103sighter
signaler945443signaler
signer74015633si_gner
siller64026053si_ller
simpler112910863simpler
singer74227313sing_er
single74520603single_
singled93914683singled
singles83520433singles
singlet84120113singlet
sizzler15266863sizzler
smuggler12244523smuggler
snigger9328373snigg_er
sniggle9316833sniggle_
sniggled11275743sniggled
snigglers11314593snigglers
sniggles10307313sniggles
soggier93410883soggier
swagger12389333swagg_er
swigged13327183swigg_ed
swiggers13337123swigg_ers
swiller103211653swi_ller
swindler12257723swindler
swinger113812563swing_er
swingier12267003swingier
swingle113510563swingle_
swingled13337433swingled
swingles12319543swingles
swizzler1963223swizzler
tagger84017703tagg_er
tangler83515073tangler
tickler133612653tickler
tiddler93110003tiddler
tiger65718633ti_g_er
tighter112910683tighter
tiler56131023ti__ler
tiller64222533ti_ller
tingle74319053tingle_
tingled93712793tingled
tinglers93710583tinglers
tingles83818313tingles
tinglier956393tinglier
tinkler113610543tinkler
tippler11348343tippler
toggle83810873toggle_
toggled10428653toggled
togglers10276953togglers
toggles93710973toggles
trigger9329163trigg_er
tugger84013103tugg_er
twangler1244113twangler
twiddler13244873twiddler
twigged13345283twigg_ed
twiggen12333503twigg_en
twinkler1564073twinkler
twirler10285203twi_rler
viler86324163vi__ler
vuggier12296813vuggier
wabbler143511923wabbler
waddler124010793waddler
waffler16377783waffler
wager95925053w_ag_er
wagerer11328493wagerer
wagged124616123wagg_ed
waggers124613083wagg_ers
waggery15276903wagg_ery
waggly14347293waggl_y
waggoner1343423waggoner
wagoner1136093wagoner
wailer93720323w_ailer
waler84229263w__aler
wangle103817503wangle_
wangled123312413wangled
wanglers123310033wanglers
wangles113416933wangles
warbler123211463warbler
warsler10289893warsler
wedgier12428273wedgier
weigher14136343weigher
weighter1535603weighter
whaler124611973w_haler
wheeler13298773wheeler
whiffler2033483whiffler
whinger1410810903whing_er
whirler13307603whirler
whistler1496313whistler
whittler1495193whittler
wicker154518673wi_cker
widder112913973wi_dder
widdle113814843widdle_
widdled133511233widdled
widdles123514343widdles
widener11318693widener
wider94826353wi__der
widget113815253widg_et
widower1435343widower
wielder11197673wielder
wiener94513543wi_ener
wifelier1434853wifelier
wiftier13297733wiftier
wiggiest13269013wiggiest
wigging133413833wigging
wiggliest1444883wiggliest
wiggling14217293wiggling
wiggy134510733wigg__y
wigless11359673wi_gless
wiglets113411423wi_glets
wigmaker1843783wigmaker
wigwagger1851373wigwagger
wilder103616473wi_lder
wile75944373wi__le_
wiled95231553wi__led
wiles85437873wi__les
wilier93217073wi_lier
willed104722453wi_lled
willers103517903wi_llers
willet95124833wi_llet
wimble133211923wimble_
wimbled15298153wimbled
wimbles143010853wimbles
wimpier14248053wimpier
wimple133611363wimple_
wimpled15338823wimpled
wimples143311173wimples
wincer115018193wi_ncer
wincher153410653wincher
winder104025263wi_nder
windier113412163windier
windle104617953windle_
windled123713483windled
windles113518493windles
winged114620833wing_ed
wingers113921483wing_ers
wingless122910023wingless
winglets12299593winglets
wingmen1336103wingmen
wingover1544303wingover
winier94522453wi_nier
winker134220293wi_nker
winkle133812833winkle_
winkled15299593winkled
winkles143412773winkles
winner94219933wi_nner
winter94222803wi_nter
wintle94014603wintle_
wintled11339843wintled
wintles103414983wintles
wiper105421293wi__per
wirer85124953wi__rer
wirier94215553wi_rier
wiselier1137363wiselier
wiser85522803wi__ser
wisher123617063wi_sher
wispier12249403wispier
wither124321353wi_ther
withier132910493withier
wittier103910823wittier
wiver115924513wi__ver
wobbler14329823wobbler
wooler93615873w_ooler
wrangler1245473wrangler
wriggly15324893wriggl_y
wringer113612453wring_er
zigged184110193zigg_ed
zinger163816703zing_er
zingier17369493zingier

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 Filter1786911340270.1701051123.5
2DLD Change Limit1340274126.58020368.8
3Display Results4124120.1402942.9
 (SQL Overall)1786914126.89025934.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.