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 “dissatisfying” 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
dissatisfying216110(None) 
dissatisfied1761253dissatisf_ied
dissatisfies1661453dissatisf_ies
dissatisfy1751663dissatisfy___
satisfying1743383___satisfying
desertifying2092874deserti_fying
disqualifying3061464disquali_fying
disseising1247644diss_eis__ing
beatifying1945735__beati_fying
citifying1845385ci___ti_fying
decertifying2292795decerti_fying
declassifying2361805declassifying
demystifying2551905demysti_fying
denazifying2892395d_enazi_fying
densifying1844815dens__i_fying
dignifying1944155di__gni_fying
disabusing1444615di_sabus__ing
disarraying1644055di_sa_rraying
discasing1339435disca__s__ing
disdaining1345995disda_i__ning
diseasing11310835disea__s__ing
disentitling1453635disenti_tling
disguising1346015di_sguis__ing
dismasting1446385disma__s_ting
dismaying1656825disma____ying
dismissing1445065di_s_mis_sing
dispatching20143525dispat__ching
dispraising1546045disprais__ing
disquantitying287855disquanti_tying
disrating11714555disrat____ing
disrelishing1752525disrelis_hing
dissatisfaction2171245dissatisfaction
dissaving1436955dissa____ving
disseating121111785disseat____ing
disseisin1046065diss_eis__in_
disseisins1145955diss_eis__ins
disseizing2147005diss_ei__zing
disseminating1754055disseminating
dissimilating1754415dissimilating
dissipating1556315diss__ipating
dissociating1655365dissoci_ating
distaining1248905dista_i__ning
distasting1248025di_s_tas_ting
distilling1247795di_s_ti_lling
diversifying2352165diversi_fying
dramatising1554395dramatis__ing
gratifying1874215__grati_fying
identifying1943495_identi_fying
justifying2444055_jus_ti_fying
kitschifying285815kitschi_fying
misassaying1752855mi_sa_ssaying
misclassifying2581225misclassifying
misraising1348125misra_is__ing
missaying1537635missa____ying
mystifying2243945_mys_ti_fying
ossifying1644255_oss__i_fying
ratifying1656825___rati_fying
russifying1743925russ__i_fying
salifying1636335___sali_fying
satisficing1751855___satisficing
satisfyingly227975___satisfyingly
scarifying1945015__scari_fying
stratifying1843525_strati_fying
testifying1745405_tes_ti_fying
visualising1544405visualis__ing

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 Limit124790658.23315157.3
3Display Results65650.0461413.0
 (SQL Overall)178691658.66920612.6
 
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.