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

238 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
curtsies103873(None) 
curtesies1147521curtesies
curtsied1134951curtsied
courtesies1246452courtesies
courtsides1343582courtsides
curacies12311762curacies
curbsides1444482curbsides
curies84934022cur__ies
curries93723162cur_ries
curses85328272cur_s_es
cursives1337102cur_sives
curtails10318242curtails
curtains10259702curtains
curtsey1255012curts_ey
curtseys1342742curtseys
cuties84927362cu_t_ies
cutises94414912cu_tises
cutties93118842cu_tties
acuities10312443acuit_ies
artsier768943_artsier
artsiest879653_artsiest
aunties73920073aunt_ies
burdies104117563bur_dies
buries84633273bur__ies
burnies94017823bur_nies
burnsides1244233burnsides
burses84425513bur_s_es
busies85525263bu__sies
butties93217953bu_tties
caresses10314063caresses
caries85147623car__ies
carnies94123963car_nies
carries94328013car_ries
carses85233653car_s_es
cartages11313313cartages
cartes86239473cart__es
catties94023053c_atties
cerastes101111093cerastes
cercises12410933cercises
cerises94722253ceris_es
certes84623083cert__es
certifies14310323certifies
ceruses93716233cerus_es
cerusites1146523cerusites
chitties13310773chitties
christies1449263christies
cissies94116153c_issies
cities84524853c_it_ies
clerisies1147253clerisies
cooties93725733coot_ies
corbies113520113cor_bies
corodies11313693corodies
corpses113913803corps_es
corries94026783cor_ries
corses84433463cor_s_es
corteges1198813corteges
cortexes1797613cortexes
cortices12615003cortices
cortins92421313cort_ins
cosies84932153c__osies
counties10316273count_ies
countries11313593countries
courses94218893cour_s_es
courtesied1344043courtesied
courtier1059313court_ier
courtiers1146683court_iers
courtlier1154453courtlier
courtliest1244893courtliest
courtships1743833courtships
courtside1243353courtside
crases85532313c_ras_es
crashes124618403c_rashes
crasis85020473c_rasi_s
crazies183413853c_razies
cresses94219813c_resses
cries75438403c_r__ies
crises84529433c_ris_es
crisis83716343c_risi_s
cronies9622503c_ronies
crosier94116573c_rosier
crosiers103312053c_rosiers
crosses94220793c_rosses
cruises93514443cruis_es
crummies1437643crummies
cruses88127713c_rus_es
crushes124215133c_rushes
crustier10259533crustier
crustiest112410043crustiest
crutches15359583crutches
cubbies133312883cu_bbies
cuddies113313263cu_ddies
cuirasses1144373cuirasses
cuishes122810823cu_ishes
cuisines1049373cu_isines
cuisses9319883cu_isses
cuittles1045903cuittles
cullies94419963cu_llies
cullises103111313cullises
cultches15316533cultches
cultisms12126713cultisms
cultists10107633cultists
cultures10310143cultures
cultuses1037753cultuses
curares94916853cur_ares
curarines11710543curarines
curaris94114773curari_s
curarizes2078173curarizes
curates95323823cur_ates
curatives1437823curatives
curbside1344673curbside
curches143512743cur_ches
curdier103312613cur_dier
curdiest112511393cur_diest
curdles103814573cur_dles
cures75645433cur___es
curettes1039313curettes
curie74533033cur__ie_
curios83218333cur__ios
curites93919863cur_ites
curlier93314183cur_lier
curliest102713113cur_liest
currie84317253cur_rie_
curried103313653cur_ried
currier93316693cur_rier
curriers103410753cur_riers
curse75829143cur_s_e_
cursed94321253cur_s_ed
curser84721473cur_s_er
cursers94317153cur_sers
cursing104217033cur_sing
cursive1237833cur_sive
cursors93910023cur_sors
curtail9299663curtai_l
curtailed1244113curtailed
curtailer1143823curtailer
curtailers1243403curtailers
curtain9319793curtai_n
curtained1265503curtained
curtals93111623curt_als
curtate9312643curtate_
curter85320073curt__er
curtest9713963curt__est
curtesy1265833curt__esy
curtness1037263curtness
curtnesses1238363curtnesses
curtseyed1551923curtseyed
curtsy1156643curts__y
curtsying1543813curtsying
curves114619283cur__ves
curvier123110663cur_vier
curviest13309673cur_viest
cusses84522773cu__sses
custodes1136653custodes
custodies1245963custodies
cutches143216453cu_tches
cutes79438313cu_t__es
cutesie937963cutesie_
cutesier1045623cutesier
cutesiest1146103cutesiest
cutie76925923cu_t_ie_
cutins83919983cu_t_ins
cutis77723753cu_t_i_s
cutlines102413273cu_tlines
cuttages11297223cuttages
cuttles93613923cu_ttles
dirties83119383dirt_ies
duresses939173duresses
durries83817353dur_ries
duties74921903du_t_ies
eurokies1246313eurokies
eustasies946023eustasies
footsies1139643footsies
forties104323863fort_ies
furies95126373fur__ies
gurries83515953gur_ries
gurshes112210033gur_shes
gussies82813303gu_ssies
gutsier8389823gu_tsier
gutsiest92610583gu_tsiest
heresies11312693heresies
hurdies114015663hur_dies
hurlies103315333hur_lies
hurries103919653hur_ries
hurtles103913753hurt_les
hussies103213293hu_ssies
juries134120633jur__ies
jutties143814003ju_tties
kurtoses12105623kurtoses
kurtosis1294403kurtosi_s
kurtosises1442693kurtosises
mortises10713603mortises
murphies1536453murphies
murries94118673mur_ries
nurses63919353nur_s_es
nurtures837443nurtures
nutsier7329253nu_tsier
nutsiest82710233nu_tsiest
outlies72421993ou_tlies
outsees72616433ou_tsees
outsides92513233ou_tsides
outsins73417863ou_tsins
outsits73215253ou_tsits
outsizes172311083ou_tsizes
outvies102214243ou_tvies
parties93230863part_ies
patsies93919483_patsies
potsies93019483_potsies
punties94520783punt_ies
purifies13311923purifies
purities10316283purities
purses84826373pur_s_es
pursier94012753pur_sier
pursiest102812123pur_siest
pursues94111373pur_sues
purtier93214093purt_ier
purtiest102414113purt_iest
pussies93615693pu_ssies
putties94420023pu_tties
quinsies1737623quinsies
qurshes19228573qur_shes
qurushes2034943qurushes
scurries102911483scur_ries
scurvies13248123scur_vies
sorties74126403sort_ies
sureties8316583sureties
surmises10310643surmises
surtaxes1536513surtaxes
tootsies848613tootsies
trusties82712853trusties
turtles72914343turt_les
tutties73216473tu_tties
unties64326923_unt_ies
urases63723563_uras_es
ursids737823_ur_sids
uruses63616503_urus_es
worthies14310283worthies
wurtzites2141943wurtzites
wussies103411083wu_ssies

Search took 10 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.1701051123.5
2DLD Change Limit1461622388.87616467.1
3Display Results2382380.0932559.1
 (SQL Overall)1786912389.13919552.6
 
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.