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

295 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
conations11131890(None) 
cognations1339591cognations
conation101420881conation_
connations12312941connations
donations101112351donations
zonations18139311zonations
adnations1039752adnations
agnations10310032agnations
carnations12311352carnations
cations94524142c__ations
citations11312502citations
coactions1349742coactions
cognation12310752cognation_
cognitions1346042cognitions
coitions10312852co_itions
collations12312852collations
conditions13410102conditions
conflations16411142conflations
connation11314262connation_
contagions1346602contagions
contains10316532contai_ns
cooptions13107762cooptions
copatrons1346332copatrons
coronations13410702coronations
creations112614542creations
crenations12511692crenations
donation91513782donation_
dotations101411632dotations
enations83316902_enations
iodations1039112iodations
lobations11219612lobations
locations112512742locations
lunations9310722lunations
monitions11310882monitions
nations74720562__nations
nonactions1248372nonactions
notations91512972notations
novations12139002novations
orations81515802_orations
ovations11149262_ovations
ozonations1945142ozonations
phonations1538312phonations
potations111615072potations
pronations12314032pronations
rogations101510822rogations
rotations91613842rotations
solations9814622solations
venations12311722venations
vocations141911422vocations
zonation171410722zonation_
ablations11311513ablations
actuations1239293actuations
acylations1547603acylations
adnation9310783adnation_
adorations11310233adorations
aerations9317903aerations
agnation9311723agnation_
alations82518893_alations
aviations12311553aviations
avocations15168683avocations
camions113916133c__amions
canakins142010463canaki_ns
cantons95221203can_t_ons
captions123813223c_aptions
carbonations1644843carbonations
carnation11312943carnation_
caseations1258303caseations
cassations1276873cassations
catenations1348363catenations
cation83925503c__ation_
caudations13108223caudations
causations1268143causations
cautions103313183c_autions
ceratins102818733cerati_ns
cessations1256473cessations
chelations1539073chelations
ciliations121111003ciliations
citation10314363citation_
clarions10310493c_larions
clavations1546183clavations
coaction12310773coaction_
coalitions1247923coalitions
coaptations1547543coaptations
coating103525313co_ati_ng
coatings113811843co_atings
coatis85122603co_ati__s
cocains111313923coca_i_ns
coercions1346203coercions
cofunctions1845013cofunctions
cogitations1448903cogitations
cognition1247013cognition_
cohesions1447093cohesions
coition9314313co_ition_
collation11313993collation_
colorations13911893colorations
comatiks16148043comati_ks
combinations1897923combinations
comminations18810483comminations
commotions1686843commotions
compactions1946543compactions
companions1697263companions
conative131214623conati_ve
conatus9310463conat__us
conceptions17410593conceptions
concisions1448243concisions
concoctions1448253concoctions
concretions1549293concretions
condition12411163condition_
condonations1548003condonations
conductions1649663conductions
confections18411393confections
conflation15412083conflation_
confusions1546303confusions
confutations1767793confutations
congelations1549733congelations
congestions1449313congestions
conins84327233con__i_ns
conjoins1738133conjoi_ns
conjugations2245863conjugations
conjurations2148493conjurations
connections15410703connections
connexions1974623connexions
conniptions1546033conniptions
connotations1447283connotations
conquians2045183conquians
conscious1347593conscious
consigns1137533con_signs
consolations1449743consolations
contagion1246993contagion_
contagious1345353contagious
contain9315833contai_n_
contemns1237403con_temns
contentions13412093contentions
contortions1348683contortions
contos84923233con_t_o_s
contractions16410403contractions
contraptions1647643contraptions
contritions13410913contritions
controls10311393con_trols
contusions1246993contusions
conurbations1646663conurbations
convections18411493convections
conventions16410533conventions
convictions1848043convictions
convocations1947363convocations
cooption1288343cooption_
copatron1246753copatron_
copulations151111113copulations
coronation12412073coronation_
corotations1349763corotations
corrasions1246353corrasions
cortins92421333co_rti_ns
cottons9312193co__ttons
countians1147333countians
cratons94316033c_rat_ons
creatins103617513creati_ns
creation102816513creation_
cremations14410713cremations
crenation11412923crenation_
cunctations1576153cunctations
damnations1337083damnations
darnations1138413darnations
decorations14312883decorations
delations102616593delations
dentations11413633dentations
detonations1239373detonations
dilations102614453dilations
dominations14611043dominations
donating10311803donati_ng
donatives13146903donatives
donators9310403donat_ors
dotation91412733dotation_
durations10311463durations
dynatrons1343393dynatrons
elations83719123_elations
elongations1244663elongations
emanations1289593emanations
enation73419233_enation_
equations1839493equations
evocations15259873evocations
fetations12511383fetations
fixations1936353fixations
flotations1366873flotations
foliations1399943foliations
formations1538203formations
foundations1543433foundations
functions1437743functions
gelations102513093gelations
gnathions1343303_gnathions
gyrations1336923gyrations
halations12312393halations
himations1438803himations
ideations1039903ideations
ignitions1045803ignitions
illations9311393illations
inactions1139323_inactions
intonations1149523intonations
iodation9310383iodation_
iodinations1268843iodinations
ionizations2049893ionizations
isolations10310693isolations
junctions1835943junctions
kations114013663__kations
lavations1238973lavations
laxations1637623laxations
legations102711923legations
lenitions939473lenitions
libations112510443libations
ligations102111993ligations
lineations1039543lineations
lobation102110553lobation_
location102113913location_
locutions11207063locutions
lotions74614763lo__tions
lunation8311923lunation_
luxations1637273luxations
mentations12312583mentations
mentions10312893men_tions
monaxons1744813mona_xons
monition10311723monition_
motions94215003mo__tions
munitions1138173munitions
mutations111211453mutations
nasions73112383__nasions
natations91412493natations
nation64322803__nation_
natrons73215663__natrons
negations102811963negations
nidations1039213nidations
nominations13410533nominations
nonaction1149443nonaction_
nonagons947223nona_gons
nonunions945583nonunions
notation81414603notation_
notions74014483__notions
novation111710013novation_
nunnations1095903nunnations
nutations91411763nutations
oblations1139373oblations
occasions1344063occasions
onions64016433_on__ions
options93810603_o_ptions
oration71617713_oration_
ovation101510023_ovation_
ozonation1845673ozonation_
phonathons1843453phonathons
phonation1439393phonation_
pinnations1236883pinnations
planations1238723planations
pontons93315553pon_t_ons
pontoons10279313pon_toons
portions10514413po_rtions
positions11811503positions
potation101716783potation_
potions93417423po__tions
probations14311083probations
pronation11415703pronation_
prorations12314463prorations
punitions1137923punitions
pupations1338123pupations
quotations19146283quotations
rations74123433__rations
relations92418333relations
rogation91612053rogation_
ronions73313343ron__ions
rotation81615453rotation_
ruinations1039603ruinations
sanctions1138873sanctions
scalations1239783scalations
sedations10311253sedations
sensations1059853sensations
sinuations1039413sinuations
solation8916153solation_
solutions988883solutions
solvations1336833solvations
sonatina849073sonati_na
sonatinas945683sonatinas
sonatine8313323sonati_ne
sonications1349953sonications
sorptions1137123sorptions
stations82415223_stations
sudations1039903sudations
tarnations1038903tarnations
taxations1636863taxations
unctions1039733_unctions
urinations10310693urinations
vacations141910553vacations
venation11513503venation_
vernations13310333vernations
vexations1937753vexations
violations1337963violations
vocation132311983vocation_
volitions1288663volitions
volutions12108393volutions
wontons103310533won_t_ons

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 Filter1786911486410.423422437.4
2DLD Change Limit1486412957.25020502.2
3Display Results2952950.1262341.3
 (SQL Overall)1786912957.79922912.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.