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

195 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
curses8532827(None) 
burses84425511burses
carses85233651carses
corses84433461corses
courses94218891courses
cruses88127711cruses
cures75645431cur_es
curies84934021curies
curse75829141curse_
cursed94321251cursed
curser84721471curser
cursers94317161cursers
curves114619281curves
cusses84522771cusses
nurses63919351nurses
purses84826371purses
arses55733872_arses
aures55137092aur_es
becurses1236722becurses
birses84717732birses
bourses94014302bourses
buries84633272buries
burkes124421312burkes
bursas85318272bursas
burse75527252burse_
bursts85116242bursts
buses75936012bu_ses
busses85023382busses
cares77369182car_es
caress85720262caress
caries85147622caries
carles85435082carles
carse74934332carse_
cartes86239472cartes
carves115128452carves
cases75048382c_ases
causes88026472causes
ceases84427072ceases
censes83721802censes
ceres75540012cer_es
cerises94722252cerises
certes84623082certes
ceruses93716232ceruses
cesses84221362cesses
chases115128232chases
choses115825132choses
cires74932912cir_es
closes85425592closes
copses104922472copses
cores76361852cor_es
corpses113913802corpses
corse75036182corse_
corset85636222corset
corsets94819802corsets
corves115122522corves
coses76949492c_oses
course85117782course_
coursed104113602coursed
courser94114802courser
coursers104412302coursers
crases85532312crases
cress75022832c_ress
cries75438402c_ries
crises84529432crises
cruces105117542cruces
crudes96218622crudes
cruises93514442cruises
cruse75726102cruse_
cruset84425092cruset
crusets93811042crusets
crushes124215132crushes
crusts84916542crusts
cruxes154911562cruxes
cubes95028162cu_bes
cues65438982cu__es
cuishes122810822cuishes
cuisse8318332cuisse
cuisses9319882cuisses
cukes115422092cu_kes
curares94916852curares
curates95323832curates
curbed114615872curbed
curber104517052curber
curbers115514382curbers
curbs94821652cur_bs
curches143512742curches
curded104217162curded
curdles103814572curdles
curds85725612cur_ds
cure66149122cur_e_
cured85932132cur_ed
curer75030752cur_er
curers84923192curers
curet75447642cur_et
curets84922342curets
curfew14426742curfew
curfews15294912curfews
curfs105122142cur_fs
curie74533042curie_
curios83218332curios
curites93919862curites
curled95021652curled
curler85221322curler
curlers94218072curlers
curlew114010902curlew
curlews12387392curlews
curls74927102cur_ls
curns74924272cur_ns
curred94319262curred
curries93723162curries
currs75624392cur_rs
curs65645542cur__s
cursives1337102cursives
cursor84110292cursor
cursors93910022cursors
curst74931022curs_t
curter85320082curter
curtest9713962curtest
curtesy1265832curtesy
curtsey1255012curtsey
curtseys1342742curtseys
curtsies1038732curtsies
curve104920022curve_
curved124815222curved
curvet114720242curvet
curvets12399912curvets
curvey144111842curvey
cusec94614902cu_sec
cusecs10509152cu_secs
cusks114916052cu_sks
cusps94913672cu_sps
cuss65430612cu_s_s
cussed94917122cussed
cusser86016092cusser
cussers94213402cussers
cussos84210002cussos
cutes79438322cu_tes
cuties84927362cuties
cutises94414912cutises
cuvees1139372cuvees
cyeses11510122cyeses
druses75517252druses
dulses73913652dulses
dures65635922dur_es
duress74712062duress
erses55826802_erses
furies95126372furies
furzes186613692furzes
fuses85628422fu_ses
fusses94920552fusses
gorses74723292gorses
guises74216312guises
gurges84716862gurges
gurshes112210032gurshes
horses94729342horses
hursts97213092hursts
juries134120632juries
lures56138532lur_es
marses84827112marses
mures75937222mur_es
murres85019042murres
muses75134302mu_ses
musses84624782musses
nurse54420122nurse_
nursed74514662nursed
nurser64314502nurser
nursers74311832nursers
parses85534702parses
perses85428062perses
pulses83818662pulses
purees84721682purees
purges94421762purges
purse76028892purse_
pursed95220882pursed
purser85020472purser
pursers93916092pursers
pursues94111372pursues
puses75532202pu_ses
pusses84322842pusses
qurshes19228572qurshes
ruses56136582ru_ses
sudses74114502sudses
surges73924592surges
susses64221052susses
torses64727952torses
turves94212692turves
tusses64921242tusses
urases63723562_urases
urges64619912_urges
uruses63616502_uruses
uses44931112_u_ses
verses94223762verses
worses95522952worses
wursts95211162wursts
wusses93314892wusses

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 Filter178691825510.703254183.5
2DLD Change Limit825511954.81317151.7
3Display Results1951950.1401392.9
 (SQL Overall)1786911955.65631593.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.