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

455 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
curran831202(None) 
currans9310611currans
currant9314171currant
buran75225302bu_ran
carman103920742carman
corban10314692corban
corral83616252corral
courlan9117762courlan
crura7312582crura_
crural8610632crural
curara83712202curara
curaras93911942curaras
curare84916952curare
curari84414402curari
curia74523762curia_
curiae84518372curiae
curial84019152curial
curn66731882cu_r_n
curr65429652curr__
currach1446452currach
curragh1344292curragh
currants1037932currants
curred94319262curred
current9313692current
currie84317252currie
curring103616842curring
currs75624392curr_s
curry105920342curr_y
curtain9319792curtain
curtal83914542curtal
durian7312002durian
durra65315792durra_
durras74713372durras
furan84320012fu_ran
hurrah12369182hurrah
hurray12459912hurray
kurgan11126782kurgan
lurdan738362lurdan
murra74519082murra_
murrain937752murrain
murras84916002murras
outran63218882outran
rurban849042rurban
surra55521342surra_
surras65919532surras
turban8310482turban
urban72013862_urban
airman82414223airman
anuran64313243anuran
arrant6623253_arrant
arras55626133_arras
array86317143_array
aura45836253au_ra_
aurae54128113au_rae
aural54428963au_ral
aurar54420253au_rar
auras55932553au_ras
aurora6411763aurora_
aurorae739663aurorae
auroral7310473auroral
auroras7311703auroras
aurorean844883aurorean
barman103519703barman
barren85317613barren
bran65740383__bran
bura66139533bu_ra_
burans85019303bu_rans
buras74736293bu_ras
burden9412473burden
bureau8712523bureau
burial84117623burial
burin75626063bu_rin
burka114617693burka_
burkas124513803burkas
burlap1098353burlap
burn65636423bu_r_n
burqa165013093burqa_
burqas174410903burqas
burr65631233burr__
burred95820723burred
burrer83718473burrer
burring104016993burring
burro75018493burr_o
burros85114993burros
burrow114610803burrow
burrs74925653burr_s
burry105221563burr_y
bursa74921523bursa_
bursae84515603bursae
bursal84414823bursal
bursar85413253bursar
bursas85318273bursas
burton8311273burton
busman10310253busman
cabman123812503cabman
caftan111710123caftan
caiman103615663caiman
cairn75717513cair_n
callan83619603callan
can57760133c___an
cancan10314103cancan
captan101613343captan
carat75048793c_arat
caravan1239223caravan
carbarn1139453carbarn
carbon104919043carbon
cardon94120853cardon
careen84119493careen
carina84325323carina
carlin84421823carlin
carmen104019343carmen
carn66245433c_ar_n
carnal83919203carnal
carpal103716253carpal
carr65434703carr__
carrack1548753carrack
carrel84718633carrel
carrion9312673carrion
carrom10513403carrom
carrot8423123carrot
carrs75730853carr_s
carry105823783carr_y
carryon1237033carryon
carton84522663carton
carven114716663carven
cateran9313763cateran
cayman133613213cayman
cedarn9408443cedarn
cercal10314123cercal
cereal8315833cereal
ceria75125353ceria_
cerias83321973cerias
certain92612213certain
charas114223593charas
chazan20269133chazan
chiral114614413chiral
chirren12388743chirren
choral115118493choral
churn105113103chur_n
churr104512853churr__
churred13409173churred
churring14298653churring
churro11448353churr_o
churros12427583churros
churrs115111513churr_s
circa9311403circa_
cirrate92413483cirrate
cirri7710723cirr_i
cirrus8349173cirrus
citral81113883citral
citrin82615403citrin
citron83112983citron
clan65633923c__lan
clean75420413c_lean
clubman1344023clubman
cobra95214403cobra_
cobras104014193cobras
copra98115463copra_
coprah133710603coprah
copras103517153copras
coral76033453c_oral
corbans11313173corbans
cordon95017293cordon
coria75828303coria_
corn69945813c_or_n
corona83817403corona
corrade101111043corrade
corrals93713853corrals
corrie83621213corrie
corsac10410173corsac
cortin82423143cortin
cotan71521783c_otan
courant9317973courant
courlans10117613courlans
cowman13910373cowman
craal74117753c_raal
crab85727673c__rab
crag75625303c__rag
cram85635493c__ram
crane75331603c__rane
crank114819613c__rank
crap85731843c__rap
craw97725263c__raw
creak115418433c_reak
cream95721343c_ream
croak115216633c_roak
croon75522783c_roon
crown105620083c_rown
crucian1146283crucian
cuirass934973cuirass
cullay113910173cullay
culpa93610963culpa_
culpae10389263culpae
cumarin1139263cumarin
cumin94616973cu_min
cummin1288783cummin
cuneal8611513cuneal
cuppa11398523cuppa_
cuppas12458593cuppas
cupric1249113cupric
cuprum1236743cuprum
cur56841983cu_r__
curacao1146293curacao
curacy1339593curacy
curagh1236553curagh
curares94916853curares
curarine10610703curarine
curaris94114773curaris
curate85226243curate
curb86732223cu_r_b
curbed114615873curbed
curber104517053curber
curbing123814023curbing
curbs94821653cu_rbs
curch124415413cu_rch
curd77634983cu_r_d
curded104217163curded
curding113515133curding
curdle95514313curdle
curds85725613cu_rds
curdy115916523cu_rdy
cure66149123cu_r_e
cured85932133cu_red
curer75030753cu_rer
curers84923183curers
cures75645433cu_res
curet75447643cu_ret
curets84922343curets
curf97538783cu_r_f
curfew14426743curfew
curfs105122143cu_rfs
curie74533033cu_rie
curies84934023curies
curing94824783curing
curio74221203cu_rio
curios83218333curios
curite85222943curite
curium10312503curium
curl66035053cu_r_l
curled95021653curled
curler85221323curler
curlew114010903curlew
curling104320183curling
curls74927103cu_rls
curly105321233cu_rly
curns74924273cu_rns
currachs1544543currachs
curraghs1442883curraghs
currajong1941453currajong
currency1545533currency
currents1038373currents
curried103313653curried
currier93316693currier
curries93723163curries
currish1238353currish
currying14196483currying
curs65645543cu_r_s
curse75829143cu_rse
cursed94321253cursed
curser84721473curser
curses85328273curses
cursing104217033cursing
cursor84110293cursor
curst74931023cu_rst
curt67051713cu_r_t
curtail9299663curtail
curtains10259703curtains
curtals93111623curtals
curtate9312643curtate
curter85320073curter
curtly1149283curtly
curtsy1156643curtsy
curule83614123curule
curve104920023cu_rve
curved124815223curved
curves114619283curves
curvet114720243curvet
curvey144111843curvey
curving133912103curving
curvy136013373cu_rvy
cushat113513693cushat
cushaw14386983cushaw
cuspal1037883cuspal
cutbank1545533cutbank
cutin75022773cu_tin
cutlas8313093cutlas
cyan96419623c__yan
cyprian1445343cyprian
dura55232113du_ra_
dural64923893du_ral
duras65727723du_ras
durbar968723durbar
durians839573durians
durion7510963durion
durn56127623du_r_n
durr55624353durr__
durrie73713253durrie
durrs65519993durr_s
errand758793_errand
errant6618733_errant
exurban1653503exurban
firman112211343firman
foreran10311793foreran
furane94015493fu_rane
furans94515953fu_rans
furfuran1463243furfuran
furred104514433furred
furring114013133furring
furrow12427743furrow
furry116719283furr_y
garron73113493garron
german9611983german
gran56335013__gran
groan65618423_groan
guan55325583gu__an
guarana886303guarana
guarani8106273guarani
gunman9299453gunman
gurry94515413gurr_y
human102716033hu_man
hurrahs13336773hurrahs
hurrays13386153hurrays
hurry114917183hurr_y
jarrah1636683jarrah
jordan1468063jordan
jura116024893ju_ra_
jural125120483ju_ral
jurant134216553ju_rant
jurat124829323ju_rat
juryman1943583juryman
kurgans12145653kurgans
kurta95113913kurta_
kurtas10349883kurtas
loran55925093_loran
lungan74710213lungan
lurdane835983lurdane
lurdans837073lurdans
macruran1244003macruran
marram10313883marram
marrano939423marrano
marron83717543marron
merman10513853merman
morgan9311373morgan
mudra83912433mudra_
mudras94212253mudras
mura65633293mu_ra_
mural75225103mu_ral
muras75329563mu_ras
murein8311763murein
murr65225133murr__
murrains1036843murrains
murre74821073murr_e
murres85019043murres
murrey114312253murrey
murrha11366453murrha
murrhas12286163murrhas
murrine9411473murrine
murrs75521293murr_s
murry105120233murr_y
organ6915393_organ
orra46120723_orra_
ourang73311063ou_rang
ourari63413543ourari
outman83115033outman
outrang83813953outrang
outrank112611973outrank
outrun63213293outrun
overran10311663overran
parian83223963parian
parral85517533parral
partan83820563partan
perron83216623perron
purana8712933pu_rana
purda82914693purda_
purdah12288753purdah
purdas92612263purdas
purin75527593pu_rin
puritan939283puritan
purlin83615863purlin
purr64925813purr__
purred94218073purred
purring104515823purring
purrs75320433purr_s
pyran10514473_pyran
quartan1636423quartan
quean143612843qu_ean
quern143610403quer_n
ran38266613___ran
reran57329103_reran
roan47234203__roan
rural55821173ru_ral
saran53730303_saran
saurian739913saurian
scurril945103scurril
scurry11419583scurr_y
serrano768453serrano
shoran94016033shoran
sierran737193sierran
sirra54416323sirra_
sirrah9379753sirrah
sirras63814863sirras
slurban944863slurban
sovran937153sovran
sporran936743sporran
suldan72611043suldan
sultan63012593sultan
sunray9310123sunray
suntan62613003suntan
supra73614253supra_
sura45740293su_ra_
surah86823253su_rah
sural55931263su_ral
suras55336323su_ras
surfman1236203surfman
surreal739223surreal
surrey94414573surrey
surtax1337843surtax
sutra54217933sutra_
sutras64818583sutras
tarpan82814293tarpan
tartan64217513tartan
tarzan152910753tarzan
terra54419653terra_
terrae62915203terrae
terrain7410833terrain
terrane72814223terrane
terras63516953terras
turbans939563turbans
tureen63312723tureen
turfman1243983turfman
turion6313163turion
turn46330383tu_r_n
turnon638193turnon
turret63121853turret
uhlan849113_uhlan
ulan46527393_u_lan
ulpan7310123_ulpan
unban72114333_unban
unman72715423_unman
urare56322553_urare
urari54619963_urari
urbane82211383_urbane
urea46528053_urea_
ureal56722683_ureal
ureas55826013_ureas
urial54823023_urial
urn35731463_u_r_n
ursa44116903_ursa_
ursae55214453_ursae
warrant10614243warrant
warren95012853warren
wirra83210823wirra_
yuan76120013yu__an
yulan8411493yu_lan
yurta86014253yurta_

Search took 7 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127164556.56317174.5
3Display Results4554550.1403250.0
 (SQL Overall)1786914556.84326113.0
 
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.