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

206 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
curr6542965(None) 
burr65631231burr
carr65434701carr
churr104512851churr
cur56841981cu_r
curb86732221curb
curd77634981curd
cure66149121cure
curer75030751curer
curf97538781curf
curl66035051curl
curn66731891curn
currs75624391currs
curry105920341curry
curs65645541curs
curt67051711curt
durr55624351durr
murr65225131murr
purr64925811purr
aura45836252aura
aurar54420252aurar
birr66022362birr
brr56921922_brr
brrr65312292brrr
buhr95315382buhr
bur55744692bu_r
bura66139532bura
burb85334672burb
burd75534262burd
burg74930362burg
burl64937182burl
burn65636432burn
burp85028882burp
burro75018492burro
burrs74925652burrs
burry105221562burry
burs65847422burs
bury95633592bury
car59165562c_ar
carb85143162carb
card710245872card
care66968372care
carer74942332carer
cark105539272cark
carl65144782carl
carn66245432carn
carp85139812carp
carrs75730852carrs
carry105823782carry
cars67364762cars
cart66570342cart
cere66741472cere
cero66329452cero
char95132152char
charr104821782charr
chirr105015902chirr
churl105913882churl
churn105113102churn
churro11448352churro
churrs115111512churrs
cire65836372cire
cirri7710722cirri
coir66327242coir
cor59960942c_or
cord76740922cord
core67263112core
corer75538872corer
corf95941482corf
cork106635692cork
corm85735382corm
corn69945812corn
cors66656442cors
cory96941512cory
court75532772court
cru57129562c_ru
crud75219612crud
cruor7310452cruor
crura7312582crura
crus65828482crus
crux135415002crux
cry89726242c_ry
cub76940942cu_b
cube85830212cube
cuber95222532cuber
cubs85832382cubs
cud67937452cu_d
cuds76730472cuds
cue57544182cu_e
cued76329562cued
cues65438982cues
cuff125327992cuff
cuif96529142cuif
cuke105824982cuke
cull65929642cull
culm85822382culm
cult66541152cult
cum76440162cu_m
cunt66243672cunt
cup76738242cu_p
cups85430822cups
curara83712202curara
curare84916952curare
curari84414402curari
curber104517052curber
curbs94821652curbs
curch124415412curch
curds85725612curds
curdy115916522curdy
cured85932132cured
curers84923192curers
cures75645432cures
curet75447642curet
curfs105122142curfs
curia74523772curia
curie74533042curie
curio74221212curio
curler85221322curler
curls74927102curls
curly105321232curly
curns74924282curns
curran8312022curran
curred94319262curred
currie84317262currie
curse75829142curse
curser84721472curser
cursor84110292cursor
curst74931022curst
curter85320082curter
curve104920022curve
curvy136013372curvy
cusk105521632cusk
cusp86021062cusp
cuss65430612cuss
cut57957662cu_t
cute66440452cute
cuter74728232cuter
cuts65841152cuts
czar156013132czar
dorr56627722dorr
dura55232112dura
dure56341812dure
durn56127632durn
duro56228022duro
durra65315792durra
durrs65519992durrs
err35626532_err
euro45325272euro
fur66637322fu_r
furl77030882furl
furor8312392furor
furry116719282furry
furs76735042furs
fury107727972fury
guar56923292guar
gurry94515412gurry
guru54623912guru
hurl76029932hurl
hurry114917182hurry
hurt77142572hurt
jura116024892jura
juror1239562juror
jury146719592jury
kuru85521802kuru
lure45142462lure
lurer54625312lurer
lurk86624162lurk
mura65633302mura
mure65941332mure
murk105527252murk
murra74519082murra
murre74821072murre
murrs75521302murrs
murry105120232murry
nurd56224342nurd
nurl45327242nurl
our36042892ou_r
ours47237562ours
parr65731152parr
pur56840552pu_r
pure65543332pure
purer75127902purer
puri65931442puri
purl65631422purl
purrs75320432purrs
purs65641042purs
ruer46127562ruer
scurf104719322scurf
scurry11419592scurry
suer45334032suer
sura45740292sura
surd56433812surd
sure45447412sure
surer54833102surer
surf76039312surf
surra55521342surra
torr45630902torr
turd56027622turd
turf75334052turf
turk86125862turk
turn46330392turn
urb55731112_urb
urd46427052_urd
urn35731472_urn
urp56426402_urp
yirr76513572yirr
yurt76435042yurt

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 Filter178691298720.296603685.8
2DLD Change Limit298722060.86034734.9
3Display Results2062060.0633269.8
 (SQL Overall)1786912061.219146588.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.