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

253 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
cry8972624(None) 
cay87155981cay
cory96941511cory
coy810557551coy
cru57129561cru
dry76526031dry
fry96226501fry
pry85728051pry
scry96017761scry
try66529671try
wry96524701wry
aby810238062aby
achy126316092achy
acre67330772acre
aery77231682aery
airy75734152airy
any68440492any
ar211379382ar_
arb510448422arb
arc510250902arc
are37874572are
arf67453372arf
ark77044962ark
arm58449622arm
army96624182army
ars37670932ars
art38679142art
arty77531312arty
aryl75922342aryl
awry107619682awry
ay511773892_ay
bay89661642bay
bey86645422bey
boy87753562boy
bra56339462bra
bray95232902bray
bro56236602bro
brr56921922brr
bury95633592bury
buy86436542buy
by77529232_by
cab78355402cab
cad67456362cad
cagy106321992cagy
caky136222442caky
cam78058982cam
can57760142can
cap76758982cap
car59165562car
carb85143162carb
card710245872card
care66968372care
cark105539272cark
carl65144782carl
carn66245432carn
carny105822922carny
carp85139812carp
carr65434702carr
carry105823782carry
cars67364762cars
cart66570342cart
cat58282342cat
cavy125920002cavy
caw86647932caw
cays95437672cays
cee55952702cee
cel56040552cel
cep75736332cep
cere66741472cere
cero66329452cero
chary135023132chary
chay124924872chay
chi86228652chi
cig67036182cig
cire65836372cire
cis57748032cis
city95122622city
clary105719612clary
clay95927412clay
cloy96623832cloy
cob710258752cob
cod69660122cod
cog69552902cog
coky137526822coky
col59360352col
coly96940532coly
con510268022con
cony96537832cony
coo59566362coo
cop711162372cop
copy116229802copy
cor59960942cor
corby125018532corby
cord76740922cord
core67263112core
corf95941482corf
cork106635692cork
corky145221152corky
corm85735382corm
corn69945812corn
corny106023272corny
cors66656442cors
cos510270392cos
cosy97232702cosy
cot510483222cot
cow89856712cow
cowry135512482cowry
cowy126427362cowy
cox1210346782cox
coys97537242coys
coz149345362coz
cozy185823802cozy
crab85727672crab
crag75625302crag
cram85635492cram
crap85731842crap
craw97725262craw
crazy195511222crazy
cred76530882cred
crepy124812702crepy
crew96122682crew
crib86323582crib
cris66233432cris
crit65743712crit
croc85723732croc
crony105918672crony
crop87628632crop
crow96428132crow
crud75219612crud
crus65828482crus
crux135415002crux
crypt123715232crypt
cub76940942cub
cud67937452cud
cue57544182cue
cum76440162cum
cup76738242cup
cur56841982cur
curb86732222curb
curd77634982curd
curdy115916522curdy
cure66149122cure
curf97538782curf
curl66035052curl
curly105321232curly
curn66731892curn
curr65429652curr
curry105920342curry
curs65645542curs
curt67051712curt
curvy136013372curvy
cut57957662cut
cwm106815082cwm
day76254112day
decry115514352decry
dey77243372dey
dory85836232dory
dray85428092dray
drys86314802drys
ecru65819532ecru
eery76129622eery
er28345142er_
era35741502era
ere36352772ere
erg45531072erg
ern35738362ern
err35626532err
ers36046282ers
eyry106315882eyry
fay97454862fay
fey95940882fey
fly97124952fly
foy96044262foy
fray105428902fray
fro65530642fro
fury107727972fury
gay76856492gay
gey75738302gey
gory86129662gory
goy77844552goy
gray85329892gray
grey85624042grey
guy75728942guy
hay97358772hay
hey96741062hey
hoy97447912hoy
icky136315752icky
icy86322122icy
ire36943172ire
irk76426362irk
ivy96317442ivy
jay136242672jay
joy137036362joy
jury146719592jury
kay106745542kay
key105833332key
lay68865352lay
ley66246812ley
lory75931712lory
may88757632may
miry96326752miry
my78125652_my
nary76931222nary
nay66952772nay
ochry13346932ochry
or27354732or_
ora37250832ora
orb55736862orb
orby97519602orby
orc57034922orc
ore36661832ore
orgy85218002orgy
ors35750112ors
ort39465232ort
oryx14510212oryx
oxy136320982oxy
oy58950132_oy
pay88461182pay
ply86323552ply
pray96331532pray
prey96228482prey
pro55837262pro
ray66361992ray
re26153742_re
rya67622012_rya
rye66032542_rye
say67264762say
scary105222592scary
shy96728192shy
sky106420992sky
sly66228562sly
soy67851452soy
spry96819122spry
spy86023742spy
sri35634002sri
sty66227312sty
thy97022912thy
tory75840542tory
toy69655192toy
tray77632592tray
trey77228792trey
troy77429682troy
urb55731112urb
urd46427052urd
urn35731472urn
urp56426402urp
vary105226062vary
very108025642very
wary106740012wary
way96757662way
why126920012why
wiry106422832wiry
yay96948712yay

Search took 1 second 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 Filter178691140840.250714764.0
2DLD Change Limit140842530.34341061.2
3Display Results2532530.0465500.0
 (SQL Overall)1786912530.639279641.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.