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

294 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
flaggy1441592(None) 
faggy136514371f_aggy
slaggy11438791slaggy
baggy125615682_baggy
braggy13337172braggy
cloggy1344872cloggy
craggy13396602craggy
draggy12346822draggy
flabby1634572flabby
flag87427082fla_g_
flagged13459632flagged
flagger12469352flagger
flagon1037982flagon
flags95321282fla_gs
flakey164410512flakey
flaky155715582fla_ky
flamy135217472fla_my
flange103411972flange
flappy1654482flappy
flashy15498172flashy
flatly123110212flatly
flawy145913382fla_wy
flaxy189012292fla_xy
flay106332802fla__y
fledgy14414912fledgy
foggy136714542f_oggy
froggy1434492froggy
fuggy135411672f_uggy
jaggy175913142_jaggy
leggy105210242_leggy
loggy105714192_loggy
naggy106612822_naggy
plaguy12386412plaguy
quaggy2084682quaggy
raggy106116572_raggy
saggy105917462_saggy
shaggy14478042shaggy
slangy105411392slangy
snaggy11488052snaggy
staggy115510392staggy
agly86821803__agly
alang66023513alang_
alary86123443ala_ry
anagogy12174443anagogy
biggy124413133_biggy
blabby1234813blabby
blasty115611053blasty
boggy126116073_boggy
buggy124613483_buggy
cadgy125210783_cadgy
cagey115917823_cagey
cagy106321993_ca_gy
clag75924573cla_g_
clagged12749233clagged
clags85621123cla_gs
clammy15356333clammy
clang86019313clang_
clangs95113613clangs
clanky15469073clanky
clary105719613cla_ry
classy11379043classy
clay95927413cla__y
clayey14407663clayey
clergy1234993clergy
clingy12659063clingy
dagga839543_dagga
doggy115214873_doggy
dreggy12364633dreggy
druggy12344743druggy
eggy96611853__eggy
elegy939303el_egy
faddy135511623f_addy
fadge104816993f_adge
faery116015483f_aery
fag76852363f_a_g_
fagged124717703f_agged
faggot1139053f_aggot
faggoty1542863f_aggoty
fagin9216573f_agin
fagot9323403f_agot
fags86939123f_a_gs
fairy115318283f_airy
fakey155515423f_akey
fancy134615483f_ancy
fang85432553f_ang_
fanga96119623f_anga
fangs96224073f_angs
fanny114816043f_anny
farcy135217093f_arcy
fatly115716803f_atly
fatty115117413f_atty
faugh125712963f_augh
fawny144711713f_awny
fay97454863f_a__y
fealty122910223fealty
featly123711753featly
flab96628353fla__b
flabs105818643fla_bs
flack144519413fla_ck
flacks154114533flacks
flacon1138633flacon
flaggers13328073flaggers
flaggier13105203flaggier
flagging14329223flagging
flagman13186173flagman
flagmen13226913flagmen
flagons1137973flagons
flail85316183fla_il
flails94313003flails
flair86114123fla_ir
flairs95711913flairs
flak116026173fla__k
flake125119973fla_ke
flaked144715653flaked
flaker134916173flaker
flakes134118873flakes
flakily1736293flakily
flam96333293fla__m
flambe13489153flambe
flame105124443fla_me
flamed124618973flamed
flamen115215993flamen
flamer114919123flamer
flames114723693flames
flams105125013fla_ms
flan76134183fla__n
flanes94522423flanes
flanged123810843flanged
flanger113412623flanger
flanges113413273flanges
flank124618093fla_nk
flanks133913403flanks
flans85327973fla_ns
flap96128703fla__p
flaps105621383fla_ps
flare84823633fla_re
flared105317603flared
flares94521703flares
flash115716213fla_sh
flask125512423fla_sk
flasks13488673flasks
flat77147823fla__t
flats86429743fla_ts
flatus94310783flatus
flaunt9712913flaunt
flaunty1354413flaunty
flauta937823flauta
flavin1239303flavin
flavor1236663flavor
flavory1644743flavory
flaw106326643fla__w
flawed134712723flawed
flaws115920343fla_ws
flax147325633fla__x
flaxen16518573flaxen
flaxes165015353flaxes
flayed134414053flayed
flayer124713563flayer
flays116321053fla_ys
flecky18387653flecky
fledge11439293fledge
fleecy14266483fleecy
fleshy15406283fleshy
fleury12417353fleury
fley106626853fl__ey
flight134014813flight
flighty17347433flighty
flimsy14345563flimsy
fling97023513fling_
flings106715283flings
flinty126112493flinty
flippy1654613flippy
flirty12499143flirty
floaty124210943floaty
flocky18468423flocky
flog85523893fl_og_
flogged13528803flogged
flogger12449463flogger
flogs95919963fl_ogs
flong95815683flong_
flongs105010493flongs
flooey123910173flooey
floosy12368153floosy
floozy21356613floozy
floppy1654873floppy
flossy12517703flossy
floury12449573floury
fluffy14315783fluffy
flukey16459813flukey
fluky154512293fl_uky
flung95114583flung_
flunky16408093flunky
flurry12397113flurry
flutey125212523flutey
fluty114415643fl_uty
fly97124953fl___y
flyaway1943163flyaway
flyboy17113913flyboy
flyby1676003fl_yby
flyway18134693flyway
foamy135313203foa_my
fogey125617873f_ogey
fogy115923183f__ogy
frag85126273fra_g_
fragged134010163fragged
frags96322163fra_gs
fray105428903fra__y
fringy13309263fringy
gladly11497933gladly
glady105413943gla_dy
glairy10448273glairy
glary96018543gla_ry
glassy10527753glassy
glazy187410983gla_zy
glegly1134873glegly
glogg837353glogg_
gloggs935033gloggs
groggy1234803groggy
hoagy124710473hoa_gy
jagg136115313_jagg_
jaggs148111493_jaggs
jiggy17549143_jiggy
kludgy15294223kludgy
lacey105820913_lacey
lacy95829633_la_cy
lady86527153_la_dy
lag47862123_la_g_
lagan66520343_lagan
lager65132863_lager
lagged95520133_lagged
lagger85919833_lagger
lags56546223_la_gs
laigh95515923_laigh
laity85318903_laity
laky116725823_la_ky
lamby125114843_lamby
lang56637383_lang_
lanky125517483_lanky
lardy96119273_lardy
large65325463_large
largo65319783_largo
larky125218873_larky
lathy115215063_lathy
laugh94414373_laugh
lawny115912013_lawny
laxly15610103_laxly
lay68865353_la__y
lazy166423073_la_zy
ledgy105712013_ledgy
lingy96925143_lingy
logy87025783_l_ogy
mangy115021243_mangy
moggy125212163_moggy
muggy125612373_muggy
ology94113113ol_ogy
orangy105111233orangy
otalgy1035353otalgy
piggy124011433_piggy
plagal948573plagal
plage84520403pla_ge
plages94520153plages
plague93610853plague
plaguey13335943plaguey
plashy14448873plashy
platy105021663pla_ty
play95928983pla__y
puggy124612323_puggy
quagga1754143quagga
ragg65622693_ragg_
raggs75216473_raggs
rangy95320383_rangy
sagy85327083_sa_gy
scraggy14304583scraggy
slag55934353sla_g_
slagged104312773slagged
slags66525903sla_gs
slang66324023slang_
slangs75615343slangs
slanty95114843slanty
slatey95417063slatey
slaty86523153sla_ty
slavey124011803slavey
slay76436383sla__y
sludgy11366253sludgy
smoggy1354283smoggy
soggy105413903_soggy
stagey105915583stagey
stagy96618893sta_gy
tangy94519933_tangy
twangy13386983twangy
twiggy1432933twiggy
vuggy13589483_vuggy
waggly14347293_waggly
wiggy134510733_wiggy

Search took 6 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 Filter1786911127160.1231452772.4
2DLD Change Limit1127162944.81323419.1
3Display Results2942940.0763868.4
 (SQL Overall)1786912945.01235652.6
 
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.