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

170 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
curie7453304(None) 
cure66149121cur_e
curia74523771curia
curiae84518371curiae
curies84934021curies
curio74221211curio
curite85222941curite
currie84317261currie
curse75829141curse
curve104920021curve
cutie76925931cutie
ourie54027301ourie
aerie54634602aerie
aurae54128112aurae
aurei54821862aurei
auric74521742auric
auris55331532auris
brie65837902_brie
burdie93615022burdie
buried94822372buried
burier84324652burier
buries84633272buries
burin75626062burin
burke115122762burke
burnie83715412burnie
burse75527252burse
care66968372car_e
caribe103416752caribe
caried94528692caried
caries85147622caries
carle74535702carle
carnie84421092carnie
carse74934332carse
carte75940422carte
carve106227752carve
cavie104621592cavie
cere66741472cer_e
ceria75125352ceria
ceric94023092ceric
cerise84822042cerise
cerite84724872cerite
cire65836372cir_e
civie103716352civie
corbie103618202corbie
core67263112cor_e
coria75828322coria
corrie83621232corrie
corse75036182corse
cosie74728272cosie
courier93617892courier
course85117782course
cowrie113814282cowrie
cozie163519132cozie
crib86323582c_rib
cried84624292c_ried
crier74724462c_rier
cries75438402c_ries
crime94822692c_rime
cripe95521142c_ripe
cris66233432c_ris
crit65743712c_rit
crude86018572crude
cruise84314042cruise
cruse75726102cruse
cube85830212cu_be
cubic114313422cubic
cubit94122892cubit
cuddie104011172cuddie
cue57544182cu__e
cuif96529142cu_if
cuke105824982cu_ke
cumin94616972cumin
cupid103212782cupid
cupric1249122cupric
cuprite1159682cuprite
cur56841982cur__
curare84916952curare
curate85226242curate
curb86732222cur_b
curbed114615872curbed
curber104517052curber
curbs94821652curbs
curch124415412curch
curd77634982cur_d
curded104217162curded
curdier103312622curdier
curdle95514312curdle
curds85725612curds
curdy115916522curdy
cured85932132cured
curer75030752curer
cures75645432cures
curet75447642curet
curf97538782cur_f
curfew14426742curfew
curfs105122142curfs
curial84019152curial
curing94824782curing
curios83218332curios
curites93919862curites
curium10312502curium
curl66035052cur_l
curled95021652curled
curler85221322curler
curlew114010902curlew
curlier93314182curlier
curls74927102curls
curly105321232curly
curn66731892cur_n
curns74924282curns
curr65429652cur_r
curred94319262curred
curried103313652curried
currier93316702currier
curries93723162curries
currs75624392currs
curry105920342curry
curs65645542cur_s
cursed94321252cursed
curser84721472curser
curses85328272curses
cursive1237832cursive
curst74931022curst
curt67051712cur_t
curter85320082curter
curule83614122curule
curved124815222curved
curves114619282curves
curvet114720242curvet
curvey144111842curvey
curvier123110662curvier
curvy136013372curvy
cute66440452cu_te
cuties84927362cuties
cutin75022782cutin
cutis77723762cutis
cuvee10316142cuvee
dure56341812dur_e
durrie73713262durrie
eerie55228532eerie
eyrie88117832eyrie
furies95126372furies
furze176815812furze
gurge75419782gurge
juried144212442juried
juries134120632juries
kyrie123712902kyrie
lure45142462lur_e
lurid64618972lurid
mure65941332mur_e
murid84520582murid
murine84220022murine
murre74821072murre
nudie65118672nudie
nurse54420122nurse
oorie53026362oorie
pure65543332pur_e
puree74632842puree
purge85324602purge
puri65931442puri_
purin75527592purin
purine85321892purine
puris75332022puris
purse76028892purse
quire144917132quire
sure45447412sur_e
surge65027692surge
urge54722422_urge
uric63624942_uric
urine55026602_urine

Search took 3 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.330541487.9
2DLD Change Limit538001701.67032215.6
3Display Results1701700.0463695.7
 (SQL Overall)1786911702.04687336.8
 
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.