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

226 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
caried9452869(None) 
carded105424901carded
cared86050091car_ed
caries85147621caries
carked134024821carked
carped115923761carped
carried103717151carried
carted98631441carted
carved124320851carved
cried84624291c_ried
varied104817861varied
acarid95017072acari_d
acred87126352acr_ed
acrid86920102acri_d
aeried74221872aeried
aired66032922_aired
arced88224162_arced
arid57642712_ari_d
ariel55228972_ariel
ariled75620322_ariled
armed86324432_armed
babied114913512babied
barbed115121312barbed
barded105426422barded
bared85144482bar_ed
barfed125416382barfed
barged105822642barged
barked135027312barked
barned95623582barned
barred95725792barred
buried94822372buried
cabbed135416262cabbed
cabined1239992cabined
cabled114819872cabled
cached145419202cached
caddied123710562caddied
cadged114812342cadged
caged95426362ca_ged
cagier93715932cagier
cahier113615772cahier
caid77837532ca_i_d
caird85717232ca_ird
cairned1037642cairned
caked126128622ca_ked
cakier123115242cakier
calked134617402calked
called94126732called
calmed114816382calmed
calved125215452calved
camped134720232camped
candied113816022candied
caned85838092ca_ned
canid85526342cani_d
canned95022062canned
canoed94618962canoed
canted94825782canted
caped104931802ca_ped
capped134721852capped
carbide126112492carbide
carcel105018672carcel
card710245872car__d
carder94524182carder
care66968372car_e_
careen84119492careen
career85822242career
carer74942332car_er
cares77369182car_es
caret75360562car_et
carex144822302car_ex
caribe103416752caribe
caribes113715642caribes
carices114220952carices
carina84325332carina
caring95137992caring
carle74535702carle_
carles85435082carles
carmen104019342carmen
carnet84732872carnet
carney115315702carney
carnie84421092carnie_
carnies94123962carnies
caroled103717692caroled
caromed123713622caromed
carpel105418472carpel
carper104923632carper
carpet104530092carpet
carrel84718632carrel
carrier93619582carrier
carries94328012carries
carse74934332carse_
carses85233652carses
carte75940422carte_
cartel85022532cartel
carter84932272carter
cartes86239472cartes
carve106227752carve_
carvel114817572carvel
carven114716662carven
carver114420152carver
carves115128452carves
cased86032412ca_sed
cashed125124352cashed
casked134815512casked
catted95422472catted
caused95117042caused
caved116227562ca_ved
cavie104621592cavie_
cavies114525002cavies
caviled1348722caviled
cawed116627062ca_wed
cered85227442cer_ed
chaired134211242chaired
chared125423692char_ed
charged144614022charged
charier124317902charier
charked174814012charked
charmed154714252charmed
charred134614482charred
charted135116852charted
citied94014142citied
claries93422202claries
copied114618572copied
corded105923352corded
cored85044222cor_ed
corked135020782corked
corned95224522corned
cosied94819892cosied
covaried1448002covaried
cozied184112162cozied
craned96121652craned
craped116120532craped
crated94827772crated
craved125417772craved
crazed184714452crazed
cred76530882c_r_ed
creed85727392c_reed
crier74724462c_rier
cries75438402c_ries
curbed114615872curbed
curded104217162curded
cured85932132cur_ed
curie74533042curie_
curies84934022curies
curled95021652curled
curred94319262curred
curried103313652curried
cursed94321252cursed
curved124815222curved
dared75935012dar_ed
darked123919632darked
darned85018482darned
darted84620922darted
dried75321382_dried
eared65139502ear_ed
earned74818332earned
faired105915772faired
farced125216532farced
farded114518952farded
fared95842342far_ed
farmed125117652farmed
farted105121782farted
fried95322912_fried
garbed104815662garbed
garred85217412garred
haired105117172haired
hared95742182har_ed
harked145422552harked
harmed125218832harmed
harped124418402harped
harried113815532harried
jarred144613252jarred
juried144212442juried
laired75216812laired
larded84319092larded
larked114519472larked
lazied164610652lazied
marked133921622marked
marled95523162marled
marred95421042marred
married104715302married
marted94425212marted
narked114116742narked
oared65030652oar_ed
paired95017522paired
pared86946762par_ed
parged104922042parged
paries84742512paries
parked134425142parked
parled94626292parled
parred95024072parred
parried103615722parried
parsed96323892parsed
parted94228682parted
partied103516552partied
pried84426862_pried
rared65738322rar_ed
scared95227292scar_ed
scarfed134711182scarfed
scarier94017872scarier
scarped124314402scarped
scarred104512632scarred
scarted104816122scarted
scried95817312scried
tared69340052tar_ed
tarred74720282tarred
tarried83914132tarried
tarted74923372tarted
taxied14509372taxied
tried65026912_tried
varier94619352varier
varies94330872varies
varved134110602varved
waired106015832waired
warded115021042warded
wared96339872war_ed
warier93722892warier
warked144421212warked
warmed124516892warmed
warned104018912warned
warped124816412warped
warred104019842warred
warted104223232warted
wearied112911812wearied
wried95518562_wried
yarded114714022yarded
yarned105514022yarned

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 Filter178691825510.360496363.9
2DLD Change Limit825512267.08011659.7
3Display Results2262260.1401614.3
 (SQL Overall)1786912267.58023574.0
 
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.