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

272 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
coition931431(None) 
coitions10312851coitions
caption113513692caption
cation83925502c_ation
caution93013522caution
chitin113114962chiti_n
chiton112612392chit_on
citron83112982c_itron
coaction12310772coaction
coalition1148702coalition
cognition1247012cognition
coitional1148692coitional
conation101420882conation
condition12411162condition
cooption1288342cooption
cortin82423152corti_n
cotton8312992co_tton
edition8310852edition
lotion65716522lo_tion
monition10311722monition
motion85217552mo_tion
notion64516582no_tion
option83612712_option
portion9615492portion
position10912192position
potion84519572po_tion
tuition738822tuition
volition1179172volition
abolition1147053abolition
abortion1048103abortion
action84719683_action
addition1096893addition
adoption1146083adoption
alation72920553alation
ambition1246563ambition
amotion9710473amotion
auction93412933auction
audition979173audition
aviation11312743aviation
bastion9312473bastion
biotin83215833bioti_n
biotron937293biotron
boston8513043bost_on
bouton8311533bout_on
caisson936593caisson
caitiff1547133caitiff
camion103917193c_amion
campion133011413campion
canton85722993cant_on
captions123813223captions
carrion9312673carrion
carton84522663cart_on
cartoon94114463cartoon
cations94524143c_ations
cautions103313183cautions
cession939813cession
chiffon1844053chiffon
chignon1344623chignon
chitins122713793chitins
chitlin12269283chitlin
chitons122611913chit_ons
chorion12311773chorion
ciliation111112493ciliation
cion613330913c___ion
cistron9299883cistron
citation10314363citation
citied94014143c_itied
cities84524853c_ities
citify1437443c_itify
citing94220183c_iting
citizen1845713c_itizen
citrin82615413c_itrin
citrons92913223c_itrons
clarion9311663clarion
clitic103315053cliti_c
clitics11279973clitics
coactions1349743coactions
coalitions1247923coalitions
coati75624643coati__
coating103525313coating
coatis85122603coati_s
cocain101315013cocai_n
cochin131313203cochi_n
cocoon10312263co_coon
codein94916723codei_n
codlin94516443codli_n
codon86522853co__don
coercion1246573coercion
coffin14339813coffi_n
cogitation13410083cogitation
cogito939203cogit_o_
cogitos1037613cogit_os
cognation12310753cognation
cognitions1346043cognitions
cogon89120903co__gon
cohesion1347283cohesion
coifing133213893coifing
coign85013913co__ign
coiling103723453coiling
coin66645353co__i_n
coining103920543coining
coital84117053coit_al
coitus8511893coit_us
cojoin1539503cojoi_n
colicin11313743colici_n
colin76231693co_li_n
colistin10410553colisti_n
colitic112916193coliti_c
colitis92617353coliti_s
collation11313993collation
collision1146943collision
colon78630193co__lon
coltish121310933coltish
comitia1139723comiti_a
comitial1248693comitial
comities12317793comities
common12310803co_mmon
commotion1576983commotion
conations111318903conations
concision1348493concision
condign1147733condign
conditions13410103conditions
conidian1168383conidian
conin76232723co_ni_n
conjoin1638203conjoin
connation11314263connation
conniption1446273conniption
consign1038773consign
contagion1246993contagion
contain9315833contain
contemn1137803contemn
conto76027173cont_o_
contos84923233cont_os
contrition12411413contrition
control9310693control
contusion1147063contusion
conviction1748183conviction
coon67248943co___on
cooptions13107763cooptions
cootie84223093cooti_e
cooties93725733cooties
copatron1246753copatron
cordon95017293co_rdon
coreign1037343coreign
cortina91915973cortina
cortins92421333cortins
cortisol1045403cortisol
cortisone1147043cortisone
cosign958783co_sign
costing104323023costing
costive12312843costive
cotan71521783co_t_an
cotillion1145283cotillion
cotillon1045053cotillon
coting94629253co_ting
cottier93814173cottier
cottons9312193co_ttons
cottony1237253co_ttony
countian1048123countian
coupon102810993co_upon
cousin8517163cousi_n
covin105621123co_vi_n
coxitis16238463coxiti_s
craton84517193crat_on
creation102816513creation
cretin82917913creti_n
crimson1135643crimson
criterion1145293criterion
critic103616813criti_c
critics112811093critics
crostino1038883crostino
croton84415453crot_on
crouton947133crout_on
cullion91910233cullion
cushion1236403cushion
cutin75022783c_uti_n
cyton101511463c_yt_on
decoction1447523decoction
diction102313053diction
dominion11147033dominion
donation91513783donation
dotation91412733dotation
editions9310403editions
elation73620453elation
elision72311103elision
elution72913823elution
emotion9711303emotion
enation73419233enation
eviction13228683eviction
faction122613333faction
fiction122010733fiction
foison948933foi_son
foliation121110793foliation
friction1347913friction
fruition11106103fruition
gonion73612833go_nion
ignition946533ignition
inion54620183__inion
iodation9310383iodation
kation104315683_kation
lection92614863lection
lenition8310083lenition
lobation102110553lobation
location102113913location
locution10227663locution
logion76013723lo_gion
lotions74614763lo_tions
mention9314373mention
minion83416243_minion
monitions11310883monitions
morion86217733mo_rion
morrion959003morrion
motions94215003mo_tions
mouton8410853mout_on
munition1038763munition
nation64322803_nation
niton55418283_nit_on
notation81414603notation
notions74014483no_tions
novation111710013novation
onion54320973_o_nion
opinion946793opinion
options93810603_options
oration71617713oration
ovation101510023ovation
paction112713963paction
petition10711753petition
pinion83815893_pinion
piton76121583_pit_on
poison8312223poi_son
ponton83217643pont_on
pontoon93010703pontoon
portions10514413portions
positions11811503positions
positron1096903positron
postin83521033posti_n
potation101716783potation
potions93417423po_tions
punition1038373punition
ration64226013_ration
rogation91612053rogation
ronion63315643ro_nion
rotation81615453rotation
ruction93611613ruction
scorpion1244803scorpion
section92515663section
sedition939333sedition
solation8916153solation
solion6616383so_lion
soliton7410233solit_on
solution889593solution
sorption1037513sorption
sortition946703sortition
station72717243station
stiction1038823stiction
suction93713043suction
taction93213023taction
titian62512663_titian
toiting83217093toiting
tompion11247103tompion
torsion7310803torsion
triton63914893trit_on
tuitions838283tuitions
unction9310663unction
virion9310683_virion
vision9311313_vision
vocation132311983vocation
volitions1288663volitions
volution1198603volution
waitron1036333waitron
wonton93410963wont_on
zonation171410723zonation

Search took 7 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 Limit1340272726.07622058.4
3Display Results2722720.0962833.3
 (SQL Overall)1786912726.57827164.9
 
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.