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

156 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
carotids1122993(None) 
carotid102014811carotid_
carotins102315581carotins
parotids112610411parotids
aroids75118222_aro_ids
carabids1338182carabids
carotidal1245132carotidal
carotin92216712caroti_n
carrotins11239952carrotins
caryatids1545212caryatids
caryotins14248042caryotins
parotid102915502parotid_
parotoids1256952parotoids
acarids105312243acar__ids
acaroid103512303acaro_id_
acrostics1346983acrostics
acrotic112515533acroti_c
acrotism1248213acrotism
acrotisms1347493acrotisms
aramids102810503_aramids
arctics1138953_arctics
aroid65428333_aro_id_
avoids104410203_avo_ids
barmaids1345933barmaids
baronies10315023baronies
bromids12278603_bromids
cactoid12311023cactoid_
caids85226423ca___ids
calorics122810463calorics
calories102919543calories
calottes10610083calottes
camelids1356933camelids
cancroids1444523cancro_ids
candids113812693ca_ndids
canids95118133ca__nids
canities101519243canities
canopies12311853canopies
capotes11314643capot_es
capsids1239333ca_psids
carabid12311333carabid_
carabins12312353carabins
carangids1344573carangids
carates95630603carat_es
carats85929023carat__s
carbide126112493car_bide
carbides133111693car_bides
carbolics1546723carbolics
cardias10715093car_dias
cardioids1345223cardioids
carditis11310213carditis
cards85137933car___ds
carets85330773caret__s
caries85147623car__ies
caritas93316943carit_as
carlins93921913car_lins
carloads1138393carloads
carnies94123963car_nies
carnotite1147353carnotite
carnotites1246543carnotites
carobs104818103caro__bs
caroches15710693caroches
caroled103717683caroled_
carolers103314173carolers
caroli85918233caroli__
caroling113317003caroling
carols85124983caro__ls
carolus94612603caro_lus
caromed123713623caromed_
caroming133312963caroming
caroms105619573caro__ms
carotene1039133carotene
carotenes11410203carotenes
carotenoids1452583carotenoids
carotinoids1452583carotinoids
carouses10614503carouses
carries94328013car_ries
carrotier1146623carrotier
carrotiest1245653carrotiest
carrotin102210883carroti_n
carrots9714623carrot__s
carted98631443car_ted_
cartels94618123car_tels
carters95327243car_ters
cartes86239473car_t_es
carting104228283car_ting
cartons94122473car_tons
cartoons104012803cartoons
carts78946293car_t__s
caryatid1447933caryatid_
caryatides1644493caryatides
caryotin13268343caryoti_n
catties94023053ca_tties
caustics1237483caustics
cavities131412613cavities
ceboids1237653cebo_ids
ceratins102818723ceratins
cerotic11415053ceroti_c
cestoids11308273cestoids
characids1745253characids
charities14312733charities
chlorids14299663chlorids
choroids1438683choroids
chromatids1847143chromatids
chromide1648053chromide
chromides1747603chromides
chronics1538683chronics
clarities11312483clarities
conoids10813883cono_ids
cooties93725733c_ooties
corodies11313693corodies
cortins92421313cor_tins
corvids1337673cor_vids
cretics112911653c_retics
cretins93216423c_retins
critics112811093c_ritics
crojiks2033173c_rojiks
cronies9622503c_ronies
crotons93714373c_rotons
crowds124910763c_ro_wds
cuboids1236723cubo_ids
cystoids14306733cystoids
droids84712583_dro_ids
erotics91914153_erotics
factoids1446243factoids
gadoids1036863gado_ids
ganoids939323gano_ids
garoted9710133garoted_
garotes8614563garot_es
garoting10510703garoting
garottes978283garottes
haloids113012543halo_ids
karyotins16234683karyotins
labroids1155833labro_ids
mantids103113623ma_ntids
martins93322063mar_tins
mastoids1177873mastoids
mattoids1196183mattoids
narcotics1374923narcotics
ootids71110353__ootids
paretics122312443paretics
parities10522973parities
parodies11313693parodies
parotic112518033paroti_c
parotitis1149173parotitis
parotoid11410023parotoid_
parties93230863par_ties
peroxids1837443peroxids
proteids11259943_proteids
rarities8316333rarities
rotis56327053__roti_s
sarcoids1137803sarcoids
sarods74918573saro__ds
sparoids11218713sparo_ids
tarots66422993tarot__s
toroids8310643toro_ids
viroids1137923viro_ids

Search took 10 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 Filter1786911461620.1731032896.0
2DLD Change Limit1461621569.06316127.3
3Display Results1561560.0602600.0
 (SQL Overall)1786911569.29619222.4
 
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.