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

74 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
prepurchasing236147(None) 
repurchasing2051961_repurchasing
prepunching2142563prepunch__ing
prepurchase20172273prepurchas__e
prepurchased22171863prepurchas_ed
prepurchases21152233prepurchas_es
purchasing1893533___purchasing
precreasing1645704pre_cr_easing
predeceasing18103064pre_deceasing
prepackaging2451504prep_ackaging
preprocessing2053554preprocessing
rephrasing1645644_rephr__asing
repurchase17142884_repurchas__e
repurchased19142364_repurchas_ed
repurchases18142924_repurchas_es
repurposing1652414_repur_posing
depurating1438645_depur__ating
enchasing1567735__e__nchasing
paraphrasing2052065paraphr__asing
perching163711635p_e__rch__ing
percussing1545225p_e__rcussing
preaccusing1843165pre__accusing
preaching172811165pre__ach__ing
precasting15169835pre___c_asting
precessing1598745pre___cessing
precharging2043755pre___charging
prechoosing1943515pre___choosing
precising14413275pre___c_ising
precuring1439425precur____ing
predicating1749655pre_dic_ating
prefocusing1953135pre_foc_using
prefocussing2052345pre_focussing
prelaunching2051505prelaunch__ing
prelocating1647415pre_loc_ating
prepacking2145775prep_ac__king
preparing14311645prep____aring
prepasting15168885prep____asting
prepaving1787235prep____aving
prepaying1747975prep____aying
preplacing1746005prep___lacing
preportioning1853605preportioning
prepossessing1862285prepossessing
prepricing1746735prep_r__icing
preprinting1647415prep_r_inting
preprograming2162485preprograming
prepunches1954015prepunches___
prereleasing1552905pre_releasing
prerinsing1347645pre__r_insing
preshaping1845425pre___shaping
pressurising1573385pressur__ising
prestressing1583975prestr_essing
presupposing1651885presu_pposing
presurveying2151355presur_veying
pretreating1448895pre_tr_eating
prevaricating2153075prevaricating
reluctating1445765_relu_ctating
repackaging2142145_rep_ackaging
repatching1844995_repatch__ing
replicating1649095_replic_ating
repressing13310395_rep_r_essing
reprising12312555_rep_r__ising
reprobating1647105_rep_robating
reprocessing1754695_reprocessing
repudiating1546205_repu_diating
repulsing1237615_repu___lsing
repurifying2043935_repur_ifying
repursuing1343015_repur__suing
resurfacing1742515_resur_facing
sepulchering2051785_sepulchering
sepulchring1951775_sepulch_ring
steeplechasing2271165steeplechasing
surceasing1345075___surceasing
trifurcating1852145trifurc_ating
uppercasing1852765_upperc_asing

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 Limit124790748.19015236.9
3Display Results74740.0461608.7
 (SQL Overall)178691748.62620715.4
 
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.