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

232 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
carotid10201481(None) 
carotids11229931carotids
carotin92216711carotin
parotid102915501parotid
acaroid103512302acaro_id
acrotic112515532acrotic
aroid65428332_aro_id
cactoid12311022cactoid
carabid12311332carabid
caroled103717682caroled
caroli85918232caroli_
caromed123713622caromed
carotidal1245132carotidal
carotins102315582carotins
carrotin102210882carrotin
carted98631442car_ted
caryatid1447932caryatid
caryotin13268342caryotin
cerotic11415052cerotic
garoted9710132garoted
parotic112518032parotic
parotids112610412parotids
parotoid11410022parotoid
acarid95017063acar__id
acrid86920103acr__id
acromia1139963acromia
acronic112814693acronic
acrostic1239943acrostic
acrotism1248213acrotism
aortic8316613_aortic
aprotic112715233aprotic
aramid93315603_aramid
arctic10313513_arctic
argotic10310273_argotic
arid57642713_ar__id
aroids75118223_aro_ids
around72712413_around
avoid95516673_avo_id
azoted16388593_azoted
azotic172711623_azotic
barmaid1238193barmaid
barytic1437823barytic
bromid112612893_bromid
cacti9318633ca_cti_
caid77837533ca___id
cajoled17428273cajoled
caloric113413213caloric
calorie92716883calorie
calotte9510563calotte
camelid1249393camelid
cancroid1346523cancro_id
candid104517853ca_ndid
canid85526343ca__nid
canoed94618953cano_ed
canonic11312933canonic
canopic1338803canopic
canopied1336333canopied
canted94825783ca_nted
cantic103920533ca_ntic
capote10315733capot_e
capotes11314643capotes
capsid11312413ca_psid
carabids1338183carabids
carabin11313213carabin
carangid1246423carangid
carat75048793carat__
carate84734003carat_e
carates95630603carates
carats85929023carat_s
carbide126112493car_bide
carbolic1448323carbolic
carbonic1439993carbonic
carboyed1637183carboyed
card710245873car___d
carded105424903car_ded
cardia9916373car_dia
cardio9915673car_dio
cardioid1247433cardioid
carditic1348693carditic
carditis11310213carditis
cared86050093car__ed
caret75360563caret__
carets85330773caret_s
caried94528693car_ied
caritas93316943caritas
carked134024823car_ked
carlin84421823car_lin
carload1039783carload
carnie84421093car_nie
carnotite1147353carnotite
caroach1488863caroach
carob95325223caro__b
carobs104818103caro_bs
caroch13911763caro_ch
caroche1469243caroche
carol75128613caro__l
caroler93816753caroler
caroling113317003caroling
carolled1138823carolled
carols85124983caro_ls
carolus94612603carolus
carom95025563caro__m
caroming133312963caroming
caroms105619573caro_ms
carotene1039133carotene
carotenoid1353863carotenoid
carotinoid1353593carotinoid
carouse9614423carouse
caroused1149253caroused
carped115923763car_ped
carpeted1338943carpeted
carpi94319393car_pi_
carried103717153carried
carromed1338563carromed
carrot8423123carrot__
carrotier1146623carrotier
carrotins11239953carrotins
carrots9714623carrot_s
carroty1248943carrot_y
cart66570343car_t__
carte75940423car_t_e
cartel85022533car_tel
carter84932273car_ter
cartes86239473car_tes
carting104228283car_ting
carton84522663car_ton
cartoned111312833cartoned
cartons94122473cartons
cartoon94114463cartoon
cartop104213563car_top
carts78946293car_t_s
carved124320853car_ved
caryatic1548483caryatic
caryatids1545213caryatids
caryotins14248043caryotins
catted95422473ca_tted
cattie85221013ca_ttie
caustic1139743caustic
cavitied14126813cavitied
cavorted1435693cavorted
ceboid11310653cebo_id
cerated103922473cerated
ceratin93020163ceratin
ceratoid1149913ceratoid
cervid1239323cer_vid
cestoid104011673cestoid
chaotic14310013chaotic
characid1646843characid
charioted1595863charioted
charquid2342903charquid
charted135116853char_ted
chlorid133211833chlorid
choroid13311793choroid
chromatid17410893chromatid
chromed153510923chromed
chromic1639853chromic
chromide1648053chromide
chronic14311413chronic
cirsoid1038123cirsoid
conoid9818883cono_id
cootie84223073c_ootie
cormoid12310403cormoid
coronoid1148943coronoid
cortin82423143cor_tin
corvid12310473cor_vid
coted85033853c__oted
crafted13419773crafted
crated94827773c_rated
cretic102816283c_retic
cretin82917913c_retin
critic103616813c_ritic
croci95818133c_roci_
crojik1934113c_rojik
crotch133410083c_rotch
croton84415453c_roton
crowd115815623c_ro_wd
crowed124717293c_rowed
cuboid1139503cubo_id
curated104717583curated
cyanotic1546613cyanotic
cymoid1459463cymo_id
cystoid13309203cystoid
darted84620923dar_ted
droid74218533_dro_id
erotic82620263_erotic
factoid1338693factoid
fagoted1236073fagoted
farted105121783far_ted
gadoid9310443gado_id
ganoid8314433gano_id
garote7717943garot_e
garotes8614563garotes
garoting10510703garoting
garotte868703garotte
garotted1066193garotted
garroted1056783garroted
haloid104317753halo_id
karstic1357983karstic
karyotin15194833karyotin
labroid1038823labro_id
maloti8313193maloti_
mantid93820373ma_ntid
marted94425213mar_ted
martin84122523mar_tin
mastoid10711223mastoid
mattoid1079273mattoid
narcotic1277913narcotic
ochroid1357903ochro_id
ootid61416693__ootid
paretic113016673paretic
parodic122311723parodic
parodied1238333parodied
paroled104217613paroled
parotoids1256953parotoids
parroted1158843parroted
parted94228683par_ted
partied103516553par_tied
peroxid17310263peroxid
proteid103513663_proteid
roti46332923__roti_
rotis56327053__rotis
sarcoid10310453sarcoid
sarod65325873saro__d
scarted104816123scar_ted
sparoid102311533sparo_id
tarot55943933tarot__
tarots66422993tarot_s
tarted74923373tar_ted
toroid7416013toro_id
viroid10411523viro_id
warted104223233war_ted
xerotic16410853xerotic

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.1561145455.1
2DLD Change Limit1340272327.03019065.0
3Display Results2322320.0932494.6
 (SQL Overall)1786912327.27924548.8
 
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.