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

157 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
connations1231294(None) 
cognations1339591cognations
conations111318901co_nations
connation11314261connation_
carnations12311352carnations
cognation12310752cognation_
cognitions1346042cognitions
collations12312852collations
conation101420882co_nation_
conditions13410102conditions
condonations1548002condonations
conflations16411142conflations
connections15410702connections
connexions1974622connexions
conniptions1546032conniptions
connotations1447282connotations
contagions1346602contagions
coronations13410702coronations
crenations12511692crenations
donations101112352do_nations
nunnations1095902nunnations
pinnations1236882pinnations
zonations18139312zo_nations
adnations1039753_adnations
agnations10310033_agnations
cannabins1365783cannabi_ns
carnation11312943carnation_
caseations1258303caseations
cassations1276873cassations
catenations1348363catenations
cations94524143c___ations
caudations13108223caudations
causations1268143causations
cessations1256473cessations
chelations1539073chelations
ciliations121111003ciliations
cinnamons1343033cinna_mons
citations11312503c_itations
clavations1546183clavations
coactions1349743co_actions
coalitions1247923coalitions
coaptations1547543coaptations
cofunctions1845013cofunctions
cogitations1448903cogitations
cognition1247013cognition_
coitions10312853co__itions
collation11313993collation_
colorations13911893colorations
combinations1897923combinations
comminations18810483comminations
commotions1686843commotions
compactions1946543compactions
companions1697263companions
conceptions17410593conceptions
concisions1448243concisions
concoctions1448253concoctions
concretions1549293concretions
condemnations1845403condemnations
condensations1646273condensations
condition12411163condition_
condonation1448853condonation_
conductions1649663conductions
confections18411393confections
conflation15412083conflation_
confusions1546303confusions
confutations1767793confutations
congelations1549733congelations
congestions1449313congestions
conjugations2245863conjugations
conjunctions2345383conjunctions
conjurations2148493conjurations
connection14410533connection_
connexion1874603connexion_
conniption1446273conniption_
connotation1347983connotation_
connoting12310023connoti_ng
consignations16105933consignations
consolations1449743consolations
contagion1246993contagion_
contagious1345353contagious
contains10316533conta_i_ns
contentions13412093contentions
continuations1547143continuations
contortions1348683contortions
contractions16410403contractions
contraptions1647643contraptions
contritions13410913contritions
contusions1246993contusions
conurbations1646663conurbations
convections18411493convections
conventions16410533conventions
convictions1848043convictions
convocations1947363convocations
cooptions13107763co_options
copatrons1346333co_patrons
copulations151111113copulations
coronation12412073coronation_
corotations1349763corotations
corrasions1246353corrasions
countians1147333coun_tians
creations112614543c_reations
cremations14410713cremations
crenation11412923crenation_
cunctations1576153cunctations
damnations1337083damnations
darnations1138413darnations
dentations11413633dentations
dominations14611043dominations
donation91513783do_nation_
dotations101411633do_tations
elongations1244663elongations
emanations1289593emanations
enations83316903__enations
foliations1399943foliations
formations1538203formations
foundations1543433foundations
iodations1039113io_dations
iodinations1268843iodinations
ionizations2049893ionizations
lineations1039543lineations
lobations11219613lo_bations
locations112512743lo_cations
lunations9310723_lunations
mentations12312583mentations
monitions11310883mo_nitions
nations74720563___nations
nominations13410533nominations
nonactions1248373nonactions
nonnational11107833nonnational
nonnationals1294893nonnationals
nonnatives1345643nonnatives
notations91512973no_tations
novations12139003no_vations
nunnation9126563nunnation_
oblations1139373_oblations
orations81515803_o_rations
ovations11149263_o_vations
ozonations1945143ozonations
phonations1538313phonations
pinnation1138013pinnation_
planations1238723planations
potations111615073po_tations
pronations12314033pronations
rogations101510823ro_gations
rotations91613843ro_tations
ruinations1039603ruinations
sensations1059853sensations
sinuations1039413sinuations
solations9814623so_lations
solvations1336833solvations
sonications1349953sonications
tarnations1038903tarnations
urinations10310693urinations
venations12311723_venations
vernations13310333vernations
vocations141911423vo_cations
zonation171410723zo_nation_

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 Filter1786911406030.436409841.7
2DLD Change Limit1406031576.07623140.7
3Display Results1571570.0961635.4
 (SQL Overall)1786911576.60827041.6
 
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.