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

53 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
moreover134486(None) 
forever1338952fore_ver
makeover17113352makeover
bereaver1346673bereaver
boilover1344023boilover
borrower1384833borrower
coroner94218203cor_oner
drover104614593_dr_over
foreboder1545743foreboder
foregoer1237253foregoer
foreseer1139013foreseer
forester11313673forester
forevers1438173fore_vers
forgiver1534183forgiver
forgoer1137693forgo_er
groover11358543_groover
holdover1544083holdover
hoover124314433ho__over
however1634513howe_ver
improver1545243impr_over
makeovers18103283makeovers
maneuver1343333maneuver
modeler1039293mode_ler
modeller1136613modeller
moderner1145523moderner
modester1197483modester
molester1099373molester
moneyer1237903mone_yer
monomer11311893mo_nomer
mooner85317833mo__oner
mooter83921093mo__oter
moreen8313343more__en
morelle91210803morelle_
morelles10710493morelles
morose85116243mor_ose_
mortiser1078473mortiser
motioner1037593motioner
mover104220863m___over
popover1495843po_pover
preaver121011613_preaver
prover113819723_pr_over
reaver94524733__reaver
recover124312623__recover
reiver95318293__reiver
remover124612273__remover
rollover1144453rollover
rover85527373__r_over
soever94412093so_e_ver
sorrower1165043sorrower
takeover15113693takeover
trover95014663_tr_over
turnover1143593turnover
voiceover1751303voiceover

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 Filter1786911461620.423422437.4
2DLD Change Limit146162537.34319904.9
3Display Results53530.0331606.1
 (SQL Overall)178691537.79922912.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.