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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

52 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
precleans134489(None) 
preclean1245891preclean_
preclears1344371preclears
recleans1037511_recleans
precleaned1543802precleaned
preclear1245422preclea_r
preplans1249612prepl_ans
reclean938522_reclean_
brechans1547413brec_hans
ceruleans1192923ceruleans
cleans85817053___cleans
overcleans15134883overcleans
pecans101515833p_ec__ans
pechans14810503p_ec_hans
pectens11189203p_ecte_ns
prebless1236823preble_ss
precedes13310713prec_edes
precent113520263prec_e_nt
precents123015043prec_ents
precepts14268893prec_epts
precess11310863prec_e_ss
prechecks2243573prechecks
precisians1446413precisians
precleaning1644263precleaning
precleared1544113precleared
preclearing1645103preclearing
precludes1445053precludes
precrease1345233precrease
precreases1445653precreases
preelects1356083preelects
preens85020113pre__e_ns
preheats1339413pre_heats
prehumans1643323prehumans
prelects1299723pre_lects
preloads1157513pre_loads
preplan1149953prepl_an_
preplant12712913prepl_ant
prescreens1443843prescreens
preteens1038123pre_teens
pretreats1146933pretreats
procreant1346253procreant
prolans9314273pr_ol_ans
proteans102811543pr_oteans
recheats1339193_recheats
reclads1049993_recl_ads
recleaned1236583_recleaned
recreant10311283_recreant
recreants1146623_recreants
relearns836303_re_learns
reloans7313133_re_loans
replans92814943_repl_ans
repleads11357213_repleads

Search took 8 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 Filter1786911486410.436409841.7
2DLD Change Limit148641526.59322545.3
3Display Results52520.0163250.0
 (SQL Overall)178691527.04525364.2
 
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.