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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

73 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
dissociations165601(None) 
dissociation1556641dissociation_
associations1445752_associations
disassociations1863162disassociations
dislocations15136982disloc_ations
dissociating1655362dissociati_ng
association1346153_association_
consociations1747513consociations
despoliations1646393despoliations
disassociation1763283disassociation_
dislocation14147503disloc_ation_
dispositions1546473disposi_tions
dissections14198263dissec__tions
disseminations1755083disseminations
dissertations1465893dissertations
dissimilations1755863dissimilations
dissipations1546533diss_ipations
dissociates1455783dissociat__es
dissociative18133733dissociati_ve
dissolutions13144923disso_lutions
mislocations16145653misloc_ations
associating1444864_associati_ng
associational1552934_associational
associationism18172604_associationism
associationist16173354_associationist
bilocations1545294bi_loc_ations
consociation1648194consociation_
defoliations1647594d_efoliations
deglaciations1753914deglaciations
denunciations1653884denunciations
depreciations1846574depreciations
desecrations1559214d_esecrations
desiccations1755654d_esiccations
desolations12310594d_eso_lations
despoliation1546714despoliation_
diazotizations2353684diazotizations
dictations1389704di___ctations
dieselizations2455914dieselizations
disassociating1862474disassociati_ng
disclamations1853724disclamations
discolorations17104304discolorations
discretions1447224di_s_cretions
disinclinations1863584disinclinations
disinflations1756294disinflations
dislocating1546734disloc_ati_ng
dispensations1655484dispensations
disposition1446684disposi_tion_
disputations15106174di_sputations
disrelations1348504di_srelations
dissection13158614dissec__tion_
dissemination1655794dissemination_
dissentions12168044diss__entions
dissertation1366094dissertation_
dissimilation1656524dissimilation_
dissimulations1754904dissimulations
dissipation1447214diss_ipation_
dissociate1346514dissociat___e
dissociated1555604dissociat__ed
dissolution12145024disso_lution_
dissuasions1243524diss__uasions
distillations1446944distillations
distortions1246614disto__rtions
divarications1955504divarications
fasciations1646264_fas_ciations
insolations1149184_inso_lations
invocations1647064_invoc_ations
isolations10310694_i_so_lations
miscitations1647054mi_s_citations
mislocation15126414misloc_ation_
mispositions1655304misposi_tions
missionizations26103574missionizations
speciations1548484__speciations
spoliations1347694__spoliations

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 Filter178691950240.703254183.5
2DLD Change Limit95024735.69016700.2
3Display Results73730.0461587.0
 (SQL Overall)178691736.43927751.4
 
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.