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

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

82 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
prefocusses185278(None) 
prefocuses1744241prefocu_ses
prefocussed1952431prefocussed
refocusses15163471_refocusses
defocusses16152842_defocusses
prefocused1843442prefocu_sed
refocuses14135952_refocu_ses
refocussed16102912_refocussed
defocuses15134493_defocu_ses
defocussed17152373_defocussed
focusses13155223___focusses
misfocusses1851993misfocusses
overfocusses2052223overfocusses
percusses1346503p_e_rcusses
preaccuses1644053preaccu_ses
precesses13310463pre__cesses
prefocus1544743prefocu___s
prefocusing1953133prefocusing
prefocussing2052343prefocussing
preprocesses1853923preprocesses
processes13310233pr__ocesses
refocused15144653_refocu_sed
repousses1146063_repo_usses
crocuses1239024cr__ocu_ses
defocused16143534_defocu_sed
focuses12159654___focu_ses
focussed14174044___focussed
hocusses13155304___hocusses
misfocuses1753094misfocu_ses
misfocussed1951594misfocussed
overfocuses1953194overfocu_ses
overfocussed2152084overfocussed
peloruses1145874p_eloru_ses
percussed1444804p_e_rcussed
perfuses1358664perf__u_ses
pertusses1145384p_e_rtusses
preaccuse1543544preaccu_se_
preaccused1743254preaccu_sed
preblesses1445104pre_blesses
precessed1437524pre__cessed
preciouses1446884preciou_ses
precises123218334pre__c_ises
precocities1748164precocities
precures12312904pre__cu_res
predeceases1653624predeceases
prefaces15311064prefac___es
prefectures1844304prefectures
prefigures1643904prefigu_res
prelocates1468354preloc_ates
premisses13288764pre__misses
premonishes1843914premonishes
preoccupies1952144preoccupies
prepossess1443084prepo__ssess
prepossesses1552914prepossesses
preprocessed1953174preprocessed
presses93523154pre____sses
prestresses1346724prestresses
princesses14206264pr_incesses
prioresses1245704pr_ioresses
processed1446804pr__ocessed
processer1346894pr__ocesser
processers1446004pr__ocessers
proclises1339544pr__oclises
procures1239214pr__ocu_res
procuress1344094pr__ocuress
procuresses1543814pr__ocuresses
professes1437874pr__ofesses
prosses94019514pr__o__sses
prowesses1437194pr__owesses
reaccuses1345694_reaccu_ses
recesses10312324_re__cesses
recourses1137734_reco_urses
recuses94619464_re__cu_ses
rediscusses1452254_rediscusses
refocus1236974_refocu___s
refocusing1653854_refocusing
refocussing1752644_refocussing
refuses104918554_ref__u_ses
rehouses11312114_reho_u_ses
repousse1046054_repo_usse_
reprocesses1545154_reprocesses
unfocussed1642094_unfocussed

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 Filter1786911488190.420425454.8
2DLD Change Limit148819828.79616918.9
3Display Results82820.0461782.6
 (SQL Overall)178691829.26219292.9
 
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.