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

153 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
cotidal103846(None) 
carotidal1245132carotidal
coital84117052co_ital
comical13312222comical
conical11316202conical
conidial1159502conidial
conoidal1149012conoidal
cordial10312942cordial
cortical12412212cortical
ecocidal1354962ecocidal
nontidal948672nontidal
tidal64516442__tidal
zooidal1745092zooidal
actinal9312293actinal
apsidal1046703apsidal
biocidal1344943biocidal
biotical1248863biotical
bridal9511453_bridal
candidal12367733candidal
capital112311523capital
capsidal1345623capsidal
carinal94318233carinal
cathodal14155413cathodal
caudal91611483c_audal
chiral114614413c_hiral
chital114313883c_hital
chordal13449883chordal
chorial124214143chori_al
choroidal1544673choroidal
citadel1044383citadel
citral81113893cit_ral
clinal8311553c_linal
cnida878953c_nida_
cnidae978143c_nidae
coaeval1245183coaeval
coal66939253co___al
coastal9411043coastal
coaxal15387303co_axal
coaxial16157003coaxial
cobia94117513cobi_a_
cobias104014993cobi_as
coccal9310223co_ccal
coccoidal1343613coccoidal
coda77029343co__da_
codas84724243co__das
codicil1246813codicil
coequal1844933coequal
coeval1138893co_eval
coil66439653co_i__l
coitional1148693coitional
colloidal1244913colloidal
comal95125133co__mal
comitial1248693comitial
conceal113313013conceal
conchal144211583conchal
congeal104011683congeal
conidia1069303conidia
conidian1168383conidian
continual1147143continual
copal95621783co__pal
coral76033453co__ral
cordials1139623cordials
coria75828323cori_a_
corneal94414503corneal
cornual94210173cornual
coronal94115763coronal
corral83616253co_rral
corrida1078503corrida_
corridas1177313corridas
corrival1346153corrival
cortina91915973cortina_
cortinas102212443cortinas
cortisol1045403cortisol
coryzal2154823coryzal
cosmical1448013cosmical
costal85419513co_stal
cotan71521783cot__an
coteau8311083cot_eau
coted85033853coted__
coting94629253coti_ng
cotinga10348023cotinga
cotingas11316323cotingas
cotta75818573cot_ta_
cottae84615703cot_tae
cottar84613813cot_tar
cottas84615573cot_tas
coxal146116673co__xal
credal9311673c_redal
creedal1037093creedal
critical12310263critical
cubical1338463cubical
cubital1137103cubital
cuboidal1344243cuboidal
curial84019153curi_al
cuspidal1343473cuspidal
cynical1437873cynical
datival1135583datival
domical1239373domical
dotal64919623dot__al
ecotonal1046253ecotonal
erotical101911983erotical
estival1036323estival
factoidal1543333factoidal
fetial95716193feti_al
fluidal1144653fluidal
forbidal1444833forbidal
fucoidal1443783fuco_idal
geoidal936713geoidal
gonadal956523gonadal
gonidial1065943gonidial
holiday1436143holiday
hyoidal1444803hyoidal
iconical1248203iconical
intimal9109943intimal
jovial1636543jovi_al
logical1038513logical
matinal9312603matinal
metical11315363metical
modal85919243mo__dal
monadal1047893monadal
motional1058673motional
mucoidal1344793muco_idal
nidal65217103__nidal
nodal64717793no__dal
nodical1049863nodical
nominal92712373nominal
nonideal947303nonideal
notal55221353not__al
notional849403notional
octal71214723oct__al
octaval1243583octaval
ogival1035873_ogival
ootid61416703ootid__
ootids71110353ootid_s
optical1149863optical
optimal1145783optimal
ovoidal1144023ovoidal
poetical12311533poetical
poundal1036403poundal
retial64724993reti_al
retinal75318353retinal
scotia8310803scoti_a_
scotias939753scoti_as
social8813333soci_al
somital939403somital
stoical9310283stoical
tical76021493__tical
topical1139953topical
toroidal966393toroidal
total55321823tot__al
toxical1637643toxical
vatical1239983vatical
vortical1348863vortical

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.390458182.1
2DLD Change Limit1340271536.70319995.1
3Display Results1531530.0463326.1
 (SQL Overall)1786911537.13925030.3
 
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.