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

164 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
giddying153378(None) 
bidding123613512bidd_ing
buddying16274792buddying
caddying16225062caddying
diddling12228742diddling
eddying1335292_eddying
fiddling14217872fiddling
gadding113411452gadd_ing
gilding103813002gild_ing
gillying13306812gillying
gipsying1533372gipsying
girding103611882gird_ing
girdling1146822girdling
godding113911942godd_ing
griddling1333932griddling
kidding14389772kidd_ing
lidding103611432lidd_ing
middling13249342middling
muddying16254542muddying
piddling13208952piddling
ridding103314192ridd_ing
riddling11249442riddling
tidying1238512ti_dying
waddying17204722waddying
widdling14228742widdling
adding93914963_add_ing
addling10229833_addling
aiding84423613ai_d_ing
bandying15218073bandying
bedding124114483bedd_ing
biddings13397563bidd_ings
biding104720793bi_d_ing
binding113819383bind_ing
birding114014923bird_ing
bodying1438973_bodying
budding123712403budd_ing
candying15188993candying
codding124014693codd_ing
coddling13258473coddling
cuddling13287653cuddling
daddling12258233daddling
dindling112411163dindling
dirtying1336093dirtying
divvying1932773divvying
dizzying2133023dizzying
drying113411603__drying
dying105316033___dying
edifying1636083edifying
fidging133910503fi_dging
finding124116543find_ing
fuddling14247153fuddling
gallying13328933gallying
gelding103911793geld_ing
gibbing13339373gi_bbing
gibing103712353gi__bing
giddied11257713gidd_ied
giddier10308723gidd_ier
giddies103713363gidd_ies
giddily1335073gidd_ily
giddy115810203giddy___
giddyap1541233giddy_ap
giddyup154863giddy_up
gieing83614853gi__eing
gifting123810893gi_fting
gigging93311773gi_gging
giggling10227043giggling
gildings11356973gild_ings
gilling93520383gi_lling
gimping133710763gi_mping
ginning93313983gi_nning
gipping133813123gi_pping
girning93210693gi_rning
girthing13256083girthing
girting93113333gi_rting
gitting93215703gi_tting
giving114313883gi__ving
gladding1236303gladding
gleying12318433g_leying
gliding103911843glid_ing
glorying1335543glorying
goading103112853goad_ing
godling103513403g_odling
grading103918713grad_ing
graying124115883g_raying
greying124110893g_reying
griding103014973grid_ing
grinding1139863grind_ing
grudging12255993grudging
guiding102911843guid_ing
gullying13367243gullying
gussying1334063gussying
guying11379723g__uying
gypsying1842183gypsying
hiding114319333hi_d_ing
hilding123713533hild_ing
hinnying15124853hinnying
howdying1933713howdying
huddling14227293huddling
idling8912883_i_dling
induing91910943_induing
inlying1168153_inlying
jimmying2342383jimmying
kindling14229623kindling
madding123711993madd_ing
meddling13257933meddling
middlings14194313middlings
milding113615453mild_ing
minding113317893mind_ing
misdoing1238803misdoing
mislying1437843mislying
mudding123310813mudd_ing
muddling13268593muddling
nidating1039783nidating
niddering1255323niddering
nidering10510483nidering
nidifying1744223nidifying
niding83217983ni_d_ing
nodding103811523nodd_ing
noddling11237263noddling
padding123412513padd_ing
paddling13218643paddling
pandying15217663pandying
peddling13217973peddling
pindling122110983pindling
pitying132910243pi_tying
podding124113183podd_ing
pudding124010803pudd_ing
puddling13218033puddling
radding103715003radd_ing
raddling11229773raddling
readying13410223readying
redding103218513redd_ing
reddling112911813reddling
redrying13209023redrying
ridging104112983ri_dging
ridgling11258203ridgling
riding84325963ri_d_ing
rodding103814533rodd_ing
ruddling11228553ruddling
saddling11239593saddling
sideling101012183sideling
siding83822133si_d_ing
sidling9915423si_dling
skidding1535463skidd_ing
sodding103712733sodd_ing
studying1335553studying
tedding103210883tedd_ing
tiding83520093ti_d_ing
toadying1335043toadying
toddling11187003toddling
twiddling1543083twiddling
undying1238503_undying
updrying1534013updrying
wadding133711943wadd_ing
waddling14237933waddling
wedding133411873wedd_ing
whidding1734573whidd_ing
widening13237833widening
widowing1635183widowing
wilding123814293wild_ing
wildling13248083wildling
willying15306713willying
winding123517913wind_ing
windling132212263windling

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.406440125.6
2DLD Change Limit1461621646.72021750.3
3Display Results1641640.0632603.2
 (SQL Overall)1786911647.18924856.2
 
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.