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

114 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
prespecifying265187(None) 
respecifying2372551_respecifying
presignifying2351793presignifying
prespecified2252593prespecif_ied
prespecifies2152933prespecif_ies
prespecify2252443prespecify___
repacifying2243543_re_pacifying
specifying2144683___specifying
esterifying1873694__esterifying
personifying2152374pers_onifying
preachifying2652344pre_achifying
premodifying2452454pre_modifying
prenotifying2153054pre_notifying
prequalifying3191424prequalifying
prescinding1744854pres__cinding
presifting1638084pres___ifting
prettifying2044004pre__ttifying
prospecting1845854prospec__ting
reedifying1845244_re__edifying
repurifying2043934_re_purifying
resinifying1844354_res_inifying
respecified1953374_respecif_ied
respecifies1853724_respecif_ies
respecify1943134_respecify___
respecting1549884_respec__ting
reverifying2143854_re_verifying
crucifying2143515cr___ucifying
decalcifying2452185_decalcifying
desertifying2092875_desertifying
etherifying2152845__etherifying
exemplifying3051515exemp_lifying
frenchifying2751735fre_nchifying
opacifying2143365___opacifying
pacifying2045505____pacifying
persecuting1643835pers_ec_uting
perspiring1544855persp__i_ring
petrifying1945825p_e__trifying
preapplying1842195preap__plying
prechecking2543075prechec__king
precising14413275pr___eci_sing
predeceasing18103065pre_deceasing
predefining1844165pre_defi_ning
preediting1447935pre__edi_ting
preelecting1646475preelec__ting
preerecting1646145preerec__ting
preexciting2343755pre_exci_ting
preexisting2144225pre__existing
prelecting15310165pre_lec__ting
preoccupying2451425pre_occupying
preopening1546245preope___ning
prepackaging2451505pre_packaging
prepacking2145775pre_pac__king
prepaying1747975pre_p___aying
prepricing1746735pre_p_ri_cing
preprinting1647415pre_p_rinting
prerecording1852115pre_recording
prescoring1547435pres__c_oring
prescribing1844555pres__cribing
preselecting1744295pres_electing
preselling1338695pres_e__lling
presenting131013025pres_e__nting
preserving1637365pres_e__rving
presetting131010835pres_e__tting
presettling1444455pres_e_ttling
preshipping1852895pres__hipping
preshrinking2252445pres_hrinking
presiding13510905pres___i_ding
preslicing1546365pres__li_cing
pressurising1573385pressuri_sing
pressurizing2463855pressuri_zing
presterilizing26122755presterilizing
presurveying2151355pres_urveying
presweetening1961375presweetening
preweighing2142335pre_we_ighing
prosecting15189815pros_ec__ting
prosecuting1645025pros_ec_uting
prospering1547175prospe___ring
recertifying2183235_recertifying
recodifying2144265_re_codifying
rectifying1946375_re__ctifying
redeciding1544705_re_deci_ding
redefying1736095_re_de__fying
refortifying2252795_refortifying
reglorifying2052045_reglorifying
reidentifying2151855_reidentifying
reifying1539385_r___e_ifying
rejustifying2652375_rejustifying
remodifying2143855_re_modifying
renotifying1844185_re_notifying
requalifying2872665_requalifying
rescinding1436725_res__cinding
resecting122816485_res_ec__ting
resecuring1345125_res_ec_uring
reseizing19311235_res_e_i_zing
resifting133512095_res___ifting
resolidifying2171535_resolidifying
respacing1438895_respac___ing
respeaking1736805_respe__aking
respelling1347975_respe__lling
respiring12159905_resp__i_ring
respiting121912865_resp__i_ting
resplicing1546295_resp_li_cing
resplitting1444945_resp_litting
respraying1636095_resp__raying
respringing1544585_resp_ringing
retestifying1993415_retestifying
reunifying1745165_re__unifying
revivifying2452855_re_vivifying
russifying1743925_rus__sifying
speciating1548125___speciating
speechifying2651665___speechifying
tepefying1843235_te_pe__fying
testifying1745405_tes__tifying
versifying2045035vers___ifying

Search took 10 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 Limit1247901149.14013653.2
3Display Results1141140.0631809.5
 (SQL Overall)1786911149.60918596.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.