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

227 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
carrell9461047(None) 
carrel84718631carre_l
carrells10359271carrells
carrels95117301carrels
barbell11429962barbell
barrel84517882barre_l
barrels94514362barrels
carcel105018672carce_l
carcels114516062carcels
carpel105418472carpe_l
carpels115315462carpels
carryall1343912carryall
cartel85022532carte_l
cartels94618122cartels
carvel114817572carve_l
carvels124914592carvels
parrel84515982parre_l
parrels94713492parrels
areal55928733_a_real
argyll1033643_argyll
ariel55228973_arie_l
ariels65119373_ariels
arrear6310253_arrear
arrest63722633_arrest
artel56122743_arte_l
artels66216233_artels
barbel104317073barbe_l
barbells12368823barbells
barbels114514433barbels
barely114716793ba_rely
bargello1144143bargello
barre75929553barre__
barred95725803barre_d
barreled1137853barreled
barrelful1442313barrelful
barrelled1245263barrelled
barren85317623barre_n
barrenly1345423barrenly
barrens94414323barrens
barres84427553barre_s
barret84930493barre_t
barrets94917103barrets
cabrilla1245833cabrilla
cadelle1039923ca_delle
cadre85419023cadre__
cadres94017933cadre_s
call66838673ca___ll
camel96822803ca_me_l
camels105217083ca_mels
cameral11311283cameral
cancel105316683cance_l
cancels114113313cancels
candela1089743candela
canella9310793ca_nella
cannel84216403canne_l
cannels93413363cannels
caracal11312513caracal
caracol11310423caracol
caracul1138823caracul
caramel11310253caramel
caramels1238803caramels
caravel1238213caravel
caravelle1444703caravelle
caravels1337443caravels
carceral1247203carceral
carded105424903carde_d
carder94524183carde_r
carders104820353carders
care66968373ca_re__
cared86050093ca_re_d
careen84119493ca_reen
careens94514703careens
career85822243ca_reer
careers95218783careers
careful1249113careful
carer74942333ca_re_r
carers85133963ca_rers
cares77369183ca_re_s
caress85720263ca_ress
caret75360563ca_re_t
carets85330773ca_rets
carex144822303ca_re_x
carful11610973ca_rful
carfuls1249133carfuls
caried94528693carie_d
caries85147623carie_s
carinal94318243carinal
cariole9818343cariole
carked134024823carke_d
carl65144783ca_r__l
carle74535703ca_r_le
carles85435083carle_s
carless95118493carless
carls77037423ca_r_ls
carmen104019343carme_n
carnal83919213ca_rnal
carnally1339523carnally
carnet84732873carne_t
carnets93918403carnets
carney115315703carne_y
carneys124310543carneys
carol75128613ca_r_ol
caroled103717693caroled
caroler93816753caroler
caroli85918233ca_roli
carols85124983ca_rols
carpal103716253ca_rpal
carpale113414353carpale
carpals113414633carpals
carped115923763carpe_d
carper104923633carpe_r
carpers114521253carpers
carpet104530093carpe_t
carpets113915333carpets
carpool1139223carpool
carr65434703carr___
carrack1548753carrack
carried103717153carried
carrier93619583carrier
carriers103614203carriers
carries94328013carries
carriole1089863carriole
carrion9312673carrion
carroch1437093carroch
carrom10513403carr_om
carroms11512403carroms
carrot8423123carr_ot
carrots9714623carrots
carroty1248943carroty
carrs75730853carr__s
carry105823783carr__y
carryalls1443523carryalls
carryon1237033carryon
carse74934333carse__
carses85233653carse_s
carte75940423carte__
carted98631443carte_d
carter84932273carte_r
carters95327253carters
cartes86239473carte_s
carve106227753carve__
carved124320853carve_d
carven114716663carve_n
carver114420153carve_r
carvers124817543carvers
carves115128453carve_s
catcall1139153catcall
catfall1237393catfall
cell65031723c___ell
cereal8315833c_ereal
chargrill1541963chargrill
charnel124010053charne_l
charnels13328173charnels
charred134614493charre_d
choreal124412223choreal
coarsely1335533coarsely
corbeil11859213corbeil
corbel103715973corbe_l
corbels113813593corbels
cordelle1148433cordelle
cormel103815603corme_l
cormels113813373cormels
corneal94414503corneal
cornel84020053corne_l
cornels94716663cornels
corral83616253corr_al
corrals93713853corrals
correct11513983correct
cowbell1445223cowbell
creel75121483c__reel
creels84416943c_reels
cruel74815903c_rue_l
cruelly1236563c_ruelly
curred94319263curre_d
current9313693current
darnel74312183darne_l
darnels83710433darnels
fardel104712593farde_l
fardels11389893fardels
farewell1443313farewell
farfel124310433farfe_l
farfels13348213farfels
ferrel92810203ferre_l
ferrels10248623ferrels
garred85217413garre_d
garret74426563garre_t
garrets84413623garrets
harebell1344353harebell
irreal657833_irreal
jarred144613253jarre_d
largely1136703largely
laurel649033laure_l
laurels746663laurels
marcel103714853marce_l
marcels113212373marcels
marred95421043marre_d
marrer83716673marre_r
marrers93414313marrers
martello1045093martello
marvel113712003marve_l
marvels123810093marvels
maxwell1942513maxwell
parcel103915473parce_l
parcels113712663parcels
parral85517533parr_al
parrals94414573parrals
parred95024073parre_d
payroll1245613payroll
quarrel1636103quarre_l
quarrels1735083quarrels
rarely93513653ra_rely
saurel6511993saure_l
saurels749303saurels
scarcely1534313scarcely
scarred104512633scarre_d
sorrel6413553sorre_l
sorrels7310723sorrels
surreal739233surreal
tarre55825633tarre__
tarred74720283tarre_d
tarres64723043tarre_s
terrella844703terrella
tramell9398703tramell
warred104019853warre_d
warren95012863warre_n
warrens103810893warrens
yarely122810303ya_rely

Search took 8 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 Filter1786911340270.406440125.6
2DLD Change Limit1340272277.34318252.3
3Display Results2272270.0802837.5
 (SQL Overall)1786912277.82922824.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.