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

65 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
disorientating168270(None) 
disorientation1583772disorientation
disorientations1683622disorientations
disorienting14155652disorien__ting
disorientate1363383disorientat__e
disorientated1562363disorientat_ed
disorientates1462853disorientat_es
misorientation1693183misorientation
misorientations1783053misorientations
misorienting15154963misorien__ting
orientating1245773___orientating
reorientating1473763_reorientating
discriminating2063954discriminating
dissertating1474794dis__sertating
chlorinating1854445chlori_n_ating
commentating1957045__commentating
decompensating2262525decompensating
deconcentrating2163085deconcentrating
denominating1645695denomi_n_ating
desalinating1476315desali_n_ating
designating1446075des__ign_ating
differentiating2371795differentiating
disadvantaging217845disadvantaging
disarticulating19102955disarticulating
discontenting1755075disconten__ting
discrediting1753215discr_e_diting
disengaging1553475dis___engaging
disentailing1484225dis___entailing
disentitling1453635dis___entitling
disgruntling1551755disgr_unt_ling
disintegrating1763305disintegrating
disinviting1664705dis__i_nviting
disjointing2045295disjoi_n__ting
disordering1444385disorde___ring
disorganizing2552635disorgan_izing
disorient10412525disorien__t___
disoriented1355265disorien__t_ed
disorients1177795disorien__t__s
dispreading1645915dispr_e__ading
disquieting2244305disquie___ting
disrating11714555dis_r____ating
disseating121111785dis__se__ating
disseminating1754055dissemin_ating
dissenting121310295dis__sen__ting
dissimilating1754415dis_similating
dissimulating1753715dis_simulating
dissipating1556315dis_si__pating
dissociating1655365dissoci___ating
distributing1654745distri__buting
districting1559005distri___cting
divaricating1953595divari__cating
dominating1449405d__omi_n_ating
fluorinating1653635fluori_n_ating
iodinating1246965_i_odi_n_ating
irritating1146295_i_rri__tating
miscreating1648495miscr_e__ating
misprinting1646825mispri_n__ting
misrelating1447275mis_r_e_lating
mistreating1449285mistr_e__ating
orientation1147575___orientation
orientations1246915___orientations
orienting1038725___orien__ting
reorientation1375595_reorientation
reorientations1465215_reorientations
reorienting1246355_reorien__ting

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.376475242.0
2DLD Change Limit95024656.06315672.8
3Display Results65650.0302166.7
 (SQL Overall)178691656.46927622.7
 
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.