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

89 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
predesignating196255(None) 
predestinating1854272predestinating
designating1446073___designating
predesignate1652843predesignat__e
predesignated1852313predesignat_ed
predesignates1762633predesignat_es
predominating1964343predomi_nating
presignaling1652853pr__esignaling
redesigning1443653_redesign__ing
pepsinating1645374p_e_psi_nating
preassigning1652924preassign__ing
predefining1844164predefi_n__ing
predestination1765484predestination
predestinations1865004predestinations
predestining1654464predestin__ing
predicating1749654pred__i_cating
predigesting1753684pred__igesting
premeditating1953654premedi_tating
prenominating1854694prenomi_nating
presignalling1761114pr__esignalling
rededicating1744334_rededi_cating
resinating11313734_r__esi_nating
codesigning1652725_codesign__ing
denigrating14146925___denigrating
desiccating1744705___desiccating
designation1347485___designation
designations1456945___designations
designative1654335___designative
designing1236625___design__ing
outdesigning1551535outdesign__ing
overdesigning1952715overdesign__ing
pedestaling1553725p_edes__taling
peregrinating1752975p_eregrinating
perennating1445545p_ere__nnating
personating1447675p_e_rs_onating
precenting151012155prece___n_ting
precipitating2074035precipi_tating
predating13514655pred_____ating
predeceasing18103065prede__ceasing
prededucting1952555prede__ducting
predestinarian1772325predestinarian
predestinarians1881945predestinarians
predestinate1595045predestinat__e
predestinated1794195predestinat_ed
predestinates1694635predestinat_es
predestinator1662985predestinat_or
predestinators1762505predestinators
predestine1349325predes____tine
predicting1649875pred__i__cting
predomination1896535predomi_nation
predominations19105545predomi_nations
preediting1447935pre_edi___ting
preenacting16125375pre_e___nacting
preexisting2144225pre_exi__sting
preflighting2252655pre_flig_hting
preheating16310725prehe____ating
preprinting1647415pre_pri_n_ting
presenting131013025pr__es_en_ting
presifting1638085pr__esi__fting
presignifying2351795pr__esignifying
pretensioning1662805pretension__ing
pretesting131810685pretes____ting
prevaricating2153075prevari_cating
preventing161210265preve___n_ting
previsioning1884085prevision__ing
previsiting1745545previsi___ting
preweighing2142335prewe_ig__hing
prizefighting3291145prizefig_hting
reassigning1343645_reassign__ing
redecorating16115055_rede_corating
redefeating1645335_rede__feating
redefining1545425_redefi_n__ing
redescending1752575_redescen_ding
redictating1546805_red__ictating
redigesting1444575_red__igesting
reescalating1553255_re_escalating
reestimating1545935_re_estimating
reigniting1246375_r__e_igniting
relegating1239485_rele__g_ating
remediating1547135_remedi__ating
remigrating1547595_r__emigrating
renominating1546425_renomi_nating
resighting1546075_r__esig_hting
resignation1247475_r__esignation
resignations1346885_r__esignations
resigning1139465_r__esign__ing
resituating1247545_r__esituating
resonating11311265_r__es_onating
undesigning1453445_undesign__ing

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.250714764.0
2DLD Change Limit95024895.92316043.2
3Display Results89890.0601483.3
 (SQL Overall)178691896.23328668.5
 
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.