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

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

64 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
misorientations178305(None) 
disorientations1683621disorientations
misorientation1693181misorientation_
disorientation1583772disorientation_
disorientating1682703disorientati_ng
orientations1246913___orientations
reorientations1465213_reorientations
disorientates1462854disorientat__es
miscegenations1963024miscegen_ations
miscitations1647054mis_ci__tations
miscorrelations1963004miscorre_lations
miscreations1647064miscr_e__ations
misorienting15154964misorien__ti_ng
orientation1147574___orientation_
reorientation1375594_reorientation_
afforestations2062245affor_estations
assentations1245835_as__sentations
chlorinations1855535chlori_n_ations
deforestations1853965defor_estations
discriminations2074605discriminations
disinfestations1993505disinfestations
disorientate1363385disorientat___e
disorientated1562365disorientat__ed
disorienting14155655disorien__ti_ng
dispensations1655485dis__pensations
disrelations1348505dis_r_e_lations
dissertations1465895dis__sertations
fermentations1856275__fermentations
fluorinations16103975fluori_n_ations
fomentations1746795__fo_mentations
forestations1546325__for_estations
implementations2162885implementations
importations16156145impor___tations
indentations1347885_i__ndentations
iodinations1268845_i_odi_n_ations
irritations1147835_i_rri__tations
marinations13411275m__ari_n_ations
memorizations2649535memori__zations
mentations12312585m_____entations
miscegenation1863135miscegen_ation_
miscitation1547775mis_ci__tation_
miscomputations2392265miscomputations
miscorrelation1873235miscorre_lation_
miscreation1547725miscr_e__ation_
misdirections1854235misdire__ctions
misorients1256005misorien__t___s
misquotations24182725mis__quotations
missionizations26103575mis_sionizations
mistranslations17122985mistranslations
misutilizations26145155misutilizations
molestations1475475m__o_lestations
motorizations2449125motori__zations
orientating1245775___orientati_ng
orientational1353805___orientational
ostentations1246125___ostentations
pigmentations1854095pi__gmentations
reforestations1754465refor_estations
reorientating1473765_reorientati_ng
sedimentations1754415__sedimentations
segmentations1655595__segmentations
solicitations1544895__solicitations
sustentations1354785__sustentations
vasodilatations197725vasodilatations
visitations1447675vis__i__tations

Search took 5 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.330541487.9
2DLD Change Limit65874643.89016934.2
3Display Results64640.0461391.3
 (SQL Overall)178691644.26641887.2
 
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.