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

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

83 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
disorientations1683621disorientations_
disorientation1583772disorientation__
misorientations1783052misorientations_
disorientating1682703disorientati_n_g
misorientation1693183misorientation__
disorientates1462854disorientat__es_
orientations1246914___orientations_
reorientations1465214_reorientations_
deforestations1853965defor_estations_
discriminations2074605discriminations_
disinfestations1993505disinfestations_
disorientate1363385disorientat____e
disorientated1562365disorientat___ed
disorienting14155655disorien__ti_n_g
dispensations1655485dis__pensations_
disrelations1348505dis_r_e_lations_
dissertations1465895dis__sertations_
orientation1147575___orientation__
orientational1353795___orientational
reorientation1375595_reorientation__
afforestations2062246affor_estations_
assentations1245836_as__sentations_
chlorinations1855536chlori_n_ations_
decompensations22103046decompensations_
deforestation1754306defor_estation__
denominations16117856denomi_n_ations_
dentations11413636d_____entations_
depigmentations21102846depigmentations_
deportations1548466depor___tations_
desalinations14410186desali_n_ations_
designations1456946des__ign_ations_
destinations13412666des_ti_n_ations_
dimerizations2548546dimeri__zations_
discretions1447226discr_e___tions_
discrimination1955356discrimination__
disinfestation18113616disinfestation__
disinflations1756296dis__inflations_
disintegrations17153636disintegrations_
disorganization2663166disorganization__
disorients1177796disorien__t___s_
dispensation1555606dis__pensation__
dispensational1762506dis__pensational
disputations15106176dis___putations_
disrelation1248816dis_r_e_lation__
disseminations1755086dissemin_ations_
dissentions12168046dis__sen__tions_
dissertation1366096dis__sertation__
dissertational1562576dis__sertational
dissimilations1755866dis_similations_
dissimulations1754906dis_simulations_
dissipations1546536dis_si__pations_
dissociations1656016dissoci___ations_
distentions12178846dis__ten__tions_
distillations1446946dis_ti_llations_
distinctions1557326dis_ti_n_ctions_
distributions1665126distri__butions_
divarications1955506divari__cations_
divinations15128416di__vi_n_ations_
documentations19144486d_ocumentations_
dominations14611046d__omi_n_ations_
fermentations1856276__fermentations_
fluorinations16103976fluori_n_ations_
fomentations1746796__fo_mentations_
forestations1546326__for_estations_
indentations1347886_i__ndentations_
iodinations1268846_i_odi_n_ations_
irritations1147836_i_rri__tations_
miscegenations1963026miscegen_ations_
miscitations1647056mis_ci__tations_
miscorrelations1963006miscorre_lations_
miscreations1647056miscr_e__ations_
misorienting15154966misorien__ti_n_g
orientating1245776___orientati_n_g
ostentations1246126___ostentations_
pigmentations1854096pi__gmentations_
reforestations1754466refor_estations_
reorientating1473766_reorientati_n_g
sedimentations1754416__sedimentations_
segmentations1655596__segmentations_
solicitations1544896__solicitations_
sustentations1354786__sustentations_
vasodilatations197726vasodilatations_
visitations1447676vis__i__tations_

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 Filter178691658740.0931921408.6
2DLD Change Limit65874836.43610235.2
3Display Results83830.0631317.5
 (SQL Overall)178691836.59227107.3
 
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.