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 “joey” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

187 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
joey14571933(None) 
joe106642351joe_
joes116635891joes
joeys15518041joeys
jokey195014691jokey
joky186215311joky
joy137036361jo_y
bey86645422_bey
body107425672body
bogey115220232bogey
bogy106426192bogy
boney105227312boney
bony96732082bony
boxy166420732boxy
boy87753562bo_y
coed77140542coed
coky137526822coky
coly96940532coly
coney105932882coney
cony96537832cony
cooey105828222cooey
copy116229802copy
cory96941512cory
cosey106226712cosey
cosy97232702cosy
covey136121782covey
cowy126427362cowy
coy810557552co_y
cozey196718542cozey
cozy185823802cozy
dey77243372_dey
doby106022162doby
doe47361952doe_
doer57734702doer
does56554472does
dogey105719512dogey
dogy96126492dogy
dopey116020352dopey
dopy106224152dopy
dory85836232dory
doty86128222doty
doxy156419952doxy
dozy175920322dozy
fey95940882_fey
fley106626852fley
foe66350812foe_
foes76543442foes
fogey125617872fogey
fogy115923182fogy
foley115222302foley
foxy176517752foxy
foy96044262fo_y
fozy197017162fozy
gey75738302_gey
gley85724652gley
goby106021082goby
goer56827102goer
goes55644092goes
gooey95522862gooey
gory86129662gory
goy77844552go_y
grey85624042grey
hey96741062_hey
hoe67562722hoe_
hoed87837982hoed
hoer76533982hoer
hoes75755732hoes
hokey155422182hokey
holey115626902holey
holy106333432holy
homey135924842homey
homy126623222homy
honey115629912honey
hooey114926602hooey
hosey116127022hosey
hoy97447912ho_y
jay136242672j_ay
jee106648642j_ee
jeed125428502jeed
jeep135624842jeep
jeer115426462jeer
jees115938542jees
jeez205622032jeez
jeon116821442jeon
jet106754822j_et
jeu105532072j_eu
jew135129082j_ew
jivey185111872jivey
jivy176213112jivy
jo99539602jo__
job128041772jo_b
jobs136529432jobs
jock176522642jock
jockey22408032jockey
jog117438312jo_g
jogs127129332jogs
john145512902john
join116724832join
joke155926162joke
joked175217912joked
joker165715892joker
jokes165423332jokes
jole117233822jole
joles125230832joles
jolly154517512jolly
jolt116639122jolt
jolty155713032jolty
jones125028182jones
josh145117612josh
joss115925592joss
jot108259022jo_t
jota116423622jota
jots116336142jots
jotty155012602jotty
jouk156015992jouk
jow137639302jo_w
jowed164724422jowed
jowl146120302jowl
jowly186410902jowly
jows146632092jows
joyed164811832joyed
joys146624662joys
jury146719592jury
key105833332_key
koel84519942koel
ley66246812_ley
logy87025782logy
looey84822912looey
lory75931712lory
moly96031912moly
money104826842money
mony96830012mony
mopey124821822mopey
mopy115721972mopy
mosey105922872mosey
motey105922952motey
noel45226552noel
noes45845392noes
nosey85619882nosey
nosy76322892nosy
obey96521302obey
oe28473062_oe_
oes35866192_oes
oozy167018132oozy
oxy136320982_oxy
oy58950132_o_y
poem86225772poem
poesy105014062poesy
poet65552902poet
pogey116017892pogey
pogy105623552pogy
pokey145318972pokey
poky135922152poky
poly96235152poly
pony96434052pony
posy96028422posy
poxy166820892poxy
prey96228482prey
quey164616472quey
roe36861082roe_
roes45954142roes
ropey106021872ropey
ropy96323412ropy
rosy76024872rosy
sooey84522432sooey
soy67851452so_y
stey76224412stey
they107223752they
toby96322292toby
tody86327212tody
toe310166852toe_
toea46732332toea
toed56137042toed
toes46956442toes
toney86027412toney
tony75635152tony
tory75840542tory
towy105325472towy
toy69655192to_y
trey77228792trey
voe67739052voe_
voes75432822voes
whey135018712whey
woe66651242woe_
woes76440662woes
zoea137118422zoea
zooey173914802zooey

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 Filter178691298720.623286823.4
2DLD Change Limit298721874.5336589.9
3Display Results1871870.0932010.8
 (SQL Overall)1786911875.24934042.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.