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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

104 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
presignifying235179(None) 
resinifying1844352_resi_nifying
personifying2152373pers_onifying
presignaling1652853presign_aling
presignalling1761113presignalling
presignified1952443presignif_ied
presignifies1852703presignif_ies
presignify1952433presignify___
prespecifying2651873prespecifying
signifying1844413___signifying
dignifying1944154___dignifying
ignifying1744314____ignifying
lignifying1843524___lignifying
preachifying2652344pre_achifying
premodifying2452454pre_modifying
prenotifying2153054pre_notifying
prequalifying3191424prequalifying
presifting1638084pres___ifting
prettifying2044004pre__ttifying
reigniting1246374_re_igni_ting
resigning1139464_resign___ing
respecifying2372554_respecifying
reunifying1745164_re__unifying
revivifying2452854_revi_vifying
signifyings1951804___signifyings
denitrifying2062665_denitrifying
desertifying2092875_desertifying
designating1446075_design_ating
designing1236625_design___ing
devitrifying2352185_devitrifying
esterifying1873695__esterifying
frenchifying2751735fre_nchifying
grecianizing2553415greciani_zing
magnifying2044035___magnifying
minifying1845825___mi_nifying
nigrifying1843845___nigrifying
opsonifying2051725_ops_onifying
petrifying1945825p_e__trifying
preassigning1652925preassign___ing
prebinding1696165prebi_n__ding
preconizing2548235pre_coni_zing
predesignating1962555predesign_ating
predigesting1753685predig_esting
prefiguring1842935prefig__uring
prefinancing2051945prefi_nancing
preguiding1544495pre__gui_ding
preignition1454435pre_igni_tion
preignitions1554005pre_ignitions
preinviting1744365pre_i_nviting
prelimiting1645385preli_mi_ting
premonishing2053425pre_monishing
prerinsing1347645preri_n__sing
presaging1339395presag____ing
prescinding1744855pres__cinding
prescribing1844555pres_cri_bing
presenting131013025pres_en__ting
preshipping1852895pres__hipping
preshrinking2252445pres_hrinking
presiding13510905pres___i_ding
preslicing1546365pres__li_cing
pressurising1573385pressuri_sing
pressurizing2463855pressuri_zing
presurveying2151355pres_urveying
preuniting1347305pre__uni_ting
previsioning1884085previ_sioning
previsiting1745545previ_si_ting
prussianising16101935prussiani_sing
prussianizing25112315prussiani_zing
recertifying2183235_recertifying
recodifying2144265_re_codifying
recognising1544545_recogni_sing
recognizing2445695_recogni_zing
rectifying1946375_re__ctifying
reedifying1845245_re__edifying
refinishing1843715_refi_nishing
refortifying2252795_refortifying
reglorifying2052045_reglorifying
reidentifying2151855_reidentifying
reifying1539385_re____ifying
reigning1039885_re_ign___ing
rejustifying2652375_rejustifying
reliquefying2851205_reliquefying
reminiscing1643795_remi_niscing
remodifying2143855_re_modifying
renotifying1844185_re_notifying
repacifying2243545_re_pacifying
repurifying2043935_re_purifying
requalifying2872665_requalifying
resifting133512095_res___ifting
resighting1546075_resig__hting
resinating11313735_resi_n_ating
resinified1445765_resi_nif_ied
resinifies1346915_resi_nif_ies
resinify1445055_resi_nify___
resining92919555_resi_n___ing
resolidifying2171535_resolidifying
retestifying1993415_retestifying
reverifying2143855_re_verifying
rigidifying2052085_r__igidifying
russifying1743925_rus__sifying
semideifying2261775_semideifying
testifying1745405_tes__tifying
versifying2045035vers___ifying
vinifying1944715___vi_nifying

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.406440125.6
2DLD Change Limit1247901048.47014733.2
3Display Results1041040.0631650.8
 (SQL Overall)1786911048.93919990.0
 
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.