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 “collocational” with Change Limit: [1] [2] [3] [4] [5]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

158 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
collocational175305(None) 
collocation1547172collocation__
collocations1646402collocation_s
convocational2054472convocational
coeducational1853293coeducational
collocating1645903collocati_n_g
connotational1554153connotational
consociational1853553consociational
locational1246593___locational
nonvocational1853703nonvocational
allocation1248574_allocation__
allocations1347774_allocation_s
avocational1645184__avocational
calculational1752584calculational
collation11313994coll__ation__
collations12312854coll__ation_s
collection1448204collec_tion__
collections1547934collec_tion_s
colligation1457444colligation__
colligations1556834colligation_s
collimation1557574collimation__
collimations1656874collimation_s
collisional1353334coll__isional
colocating1548624co_locati_n_g
coloration12913184co_loration__
colorations13911894co_loration_s
combinational1984084combinational
compositional1974054compositional
computational1994574computational
conformational21153714conformational
conjugational2353694conjugational
connectional1646724connec_tional
contractional1756064contractional
convectional1947044convec_tional
convocation1847884convocation__
convocations1947364convocation_s
correctional1675324correc_tional
correlational15113674correlational
explorational2252554explorational
invocational1754414_invocational
prevocational2054014prevocational
vocational1546954___vocational
accommodational2471555accommodational
allocating1347385_allocati_n_g
allocution1244085_allocution__
allocutions1353985_allocution_s
associational1552935_associational
bilocation1446125_bilocation__
bilocations1545295_bilocation_s
citational1266465c___itational
civilizational2871675civilizational
coeducation1646235coeducation__
coeducationally23102355coeducationally
coeducations1745875coeducation_s
cognitional1454275co__gnitional
coitional1148695c___o_itional
collaboration1763005collaboration__
collaborations1872745collaboration_s
collateral1244115coll__at_eral
collating12312765coll__ati_n_g
collecting1548285collec_ti_n_g
colligating1545705colligati_n_g
collimating1645425collimati_n_g
collocate1348675collocat____e
collocated1546165collocat___ed
collocates1448125collocat___es
collodion1244985collo__dion__
collodions1344595collo__dion_s
colloidal1244915collo___i_dal
colloquial2153075collo_qui__al
communicational2383075communicational
compensational2073525compensational
complication2048205complication__
complications2147435complication_s
conceptional1856915co_nceptional
concoction1348235concoc_tion__
concoctions1448255concoc_tion_s
condensational1753655condensational
conditional1447115co__nditional
condonation1448855condonation__
condonations1548005condonation_s
confirmational21153395confirmational
confrontational2071595confrontational
conglobation1754255conglobation__
conglobations1853945conglobation_s
congregational1863435congregational
conjunctional2454165conjunctional
connotation1347985connotation__
connotations1447285connotation_s
conservational1955345conservational
consociation1648195consociation__
consociations1747515consociation_s
consolation13410985consolation__
consolations1449745consolation_s
conspirational1853965conspirational
conventional1757165co_nventional
conversational1954165conversational
coronation12412075co_ronation__
coronations13410705co_ronation_s
corotation12410975co_rotation__
corotations1349765co_rotation_s
corporation151210655corporation__
corporations16129485corporation_s
coruscation1545695coruscation__
coruscations1645245coruscation_s
declinational1652925declinational
dilatational1352775_dilatational
dislocation14147505dislocation__
dislocations15136985dislocation_s
echolocation1952815echolocation__
echolocations2052625echolocation_s
educational1444875__educational
foundational1652855fo_undational
illocutionary1861315_illocutionary
inclinational1553935inclinational
indicational1545755_indicational
inflectional1754385inflec_tional
innovational1553835_innovational
intonational1256005_intonational
irrotational1254025_irrotational
lactational1344655__lactational
librational1344555__librational
location102113915___location__
locationally17124715___locationally
locations112512745___location_s
mislocation15126415mislocation__
mislocations16145655mislocation_s
motivational1753915mo_tivational
multinational1553765multinational
noneducational1762525noneducational
nonfictional1754855nonfic_tional
nonnational11107835no__nnational
nonrational11109125no__nrational
notational1048125___notational
occasional1453375_o__ccasional
occupational1883005_occupational
ochlocratical1961435ochlocrati_cal
operational1347525_o_perational
oppositional1683845_oppositional
oscillational1552225oscill__ational
ovational1246855____ovational
perorational1446395_perorational
pollination1348015pollination__
pollinations1447235pollination_s
populational1654415po_pulational
postulational1553915postulational
probational1547085__probational
reallocation1454495reallocation__
reallocations1553805reallocation_s
reflectional1753995reflec_tional
relational1047715_rel__ational
relocation12312115_relocation__
relocations13311145_relocation_s
rotational1048095___rotational
salutational1253325_salutational
salvational1443715_sal_vational
valuational1444045_val_uational
volitional1345415vo_l__itional

Search took 9 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 Filter1786911247900.390458182.1
2DLD Change Limit1247901588.09315419.5
3Display Results1581580.0961645.8
 (SQL Overall)1786911588.57920828.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.