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

194 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
curse7582914(None) 
burse75527251burse
carse74934331carse
corse75036181corse
course85117781course
cruse75726101cruse
cure66149121cur_e
cures75645431cures
curie74533041curie
curs65645541curs_
cursed94321251cursed
curser84721471curser
curses85328271curses
curst74931021curst
curve104920021curve
nurse54420121nurse
purse76028891purse
arse46539272_arse
aurae54128112aurae
aures55137092aures
becurse1136182becurse
birse74517402birse
bourse84414332bourse
burke115122762burke
burs65847422burs_
bursa74921522bursa
bursae84515602bursae
burses84425512burses
burst75332242burst
care66968372car_e
cares77369182cares
carle74535702carle
cars67364762cars_
carses85233652carses
carte75940422carte
carve106227752carve
case65848082c_ase
cause75225352cause
cease75227652cease
cense75121402cense
cere66741472cer_e
ceres75540012ceres
cerise84822042cerise
ceruse83914522ceruse
chase105127122chase
chose105925402chose
cire65836372cir_e
cires74932912cires
close76425222close
coarse84813902coarse
copse95623922copse
core67263112cor_e
cores76361852cores
corpse104013402corpse
cors66656442cors_
corses84433462corses
corset85636222corset
coursed104113602coursed
courser94114802courser
courses94218892courses
crude86018572crude
cruise84314042cruise
crus65828482crus_
cruses88127712cruses
cruset84425092cruset
crush106815992crush
crust75827662crust
cube85830212cu_be
cubes95028162cubes
cubs85832382cubs_
cuds76730472cuds_
cue57544182cu__e
cues65438982cues_
cuish10313172cuish
cuisse8318332cuisse
cuke105824982cu_ke
cukes115422092cukes
cups85430822cups_
cur56841982cur__
curare84916952curare
curate85226242curate
curb86732222cur_b
curbed114615872curbed
curber104517052curber
curbs94821652curbs
curch124415412curch
curd77634982cur_d
curded104217162curded
curdle95514312curdle
curds85725612curds
curdy115916522curdy
cured85932132cured
curer75030752curer
curet75447642curet
curf97538782cur_f
curfew14426742curfew
curfs105122142curfs
curia74523772curia
curiae84518372curiae
curies84934022curies
curio74221212curio
curite85222942curite
curl66035052cur_l
curled95021652curled
curler85221322curler
curlew114010902curlew
curls74927102curls
curly105321232curly
curn66731892cur_n
curns74924282curns
curr65429652cur_r
curred94319262curred
currie84317262currie
currs75624392currs
curry105920342curry
cursers94317162cursers
cursive1237832cursive
cursor84110292cursor
curt67051712cur_t
curter85320082curter
curtsey1255012curtsey
curtsy1156642curtsy
curule83614122curule
curved124815222curved
curves114619282curves
curvet114720242curvet
curvey144111842curvey
curvy136013372curvy
cusec94614902cu_sec
cusk105521632cu_sk
cusp86021062cu_sp
cuss65430612cu_ss
cussed94917122cussed
cusser86016092cusser
cusses84522772cusses
cusso74912292cusso
cute66440452cu_te
cutes79438322cutes
cutie76925932cutie
cuts65841152cuts_
cuvee10316142cuvee
druse64817662druse
dulse65415042dulse
dure56341812dur_e
dures65635922dures
durst66125172durst
furs76735042furs_
furze176815812furze
fuse76429992fu_se
gorse65926812gorse
guise64717712guise
gurge75419782gurge
gursh94512332gursh
horse86132652horse
hurst85527192hurst
lure45142462lur_e
lures56138532lures
marse76231152marse
morse76032702morse
mure65941332mur_e
mures75937222mures
murre74821072murre
muse67136032mu_se
nursed74514662nursed
nurser64314502nurser
nurses63919352nurses
ourie54027302ourie
ours47237562ours_
parse75236992parse
perse75429522perse
pulse74219972pulse
pure65543332pur_e
puree74632842puree
purge85324602purge
purs65641042purs_
pursed95220882pursed
purser85020472purser
purses84826372purses
pursue84512252pursue
pursy105016412pursy
qursh174110842qursh
ruse45938932ru_se
sure45447412sur_e
surge65027692surge
terse55026822terse
torse55833332torse
urase54624692_urase
urge54722422_urge
ursa44116912_ursa
ursae55214452_ursae
use36835162_u_se
verse84723582verse
worse86525262worse
wurst85122992wurst

Search took 2 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 Filter178691538000.310576422.6
2DLD Change Limit538001941.53335094.6
3Display Results1941940.0464217.4
 (SQL Overall)1786911941.88994595.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.