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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

102 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
overplots143695(None) 
overplot1338541overplot_
overblows1745002overblows
overflows1845112overflows
overlets112312362over_lets
overplans14249572overplans
overplants15227332overplants
overplays17287012overplays
overplies14310462overplies
overplus1336062overpl_us
overshots1546622overshots
coverlets1437053cover_lets
marplots1245633_marplots
merlots92710123_mer_lots
ocelots977233oce__lots
outplots1086363o_utplots
overacts1339653over_acts
overalls11410393overal_ls
overbeats14279823overbeats
overbets132510683over_bets
overblouse1544013overblouse
overblow1645033overblo_w
overblown1743953overblown
overbooks1855873overbooks
overcasts14217853overcasts
overclass1436963overclass
overclose1447013overclose
overcloud1544743overcloud
overclouds1643493overclouds
overcoats1438863overcoats
overcolors15124823overcolors
overcooks1875763overcooks
overcools1476773overcools
overcrops1646543overcrops
overcuts1337513over_cuts
overdoes121212543over_does
overdogs13127493over_dogs
overeats112415263over_eats
overedits1346813overedits
overemote1447193overemote
overemotes1546703overemotes
overexploits2462643overexploits
overflies1539103overflies
overflood1644523overflood
overfloods1743433overfloods
overflow1754923overflo_w
overflown1843713overflown
overgrows1645323overgrows
overheats15229993overheats
overholds16206333overholds
overhot13411223over_hot_
overhunts15245743overhunts
overjoys2135183over_joys
overlaps13219523over_laps
overlate11716283over_late
overlays14239693over_lays
overlet102619033over_let_
overlies112417043over_lies
overlit102714743over_lit_
overload12119283over_load
overloads13127663over_loads
overlong1238123over_long
overlook1596423over_look
overlooks1685483overlooks
overlord12119183over_lord
overlords13117223over_lords
overloud12117753over_loud
overlove14239173over_love
overloves15218673over_loves
overmelts1447263overmelts
overpacks2075963overpacks
overpass13258653overp_ass
overpast132611023overpast_
overpays16248253overp_ays
overpert13312993overpert_
overplaid1546813overplaid
overplaids1645433overplaids
overplan13258943overpl_an
overplant142510713overplant
overplay16257553overpl_ay
overplied1539053overplied
overplotted1743903overplotted
overpluses1545783overpluses
overply15227653overpl__y
overprints1546813overprints
overproof1745533overproof
overproud1545483overproud
overpumps1843433overpumps
oversalts1238163oversalts
oversets113114173over_sets
overshoes1538863overshoes
overshoots1644393overshoots
overshot1449433overshot_
overslips1446763overslips
overslow1435693overslo_w
overtops1338513over_tops
overvote1438953over_vote
overvotes1538423over_votes
overwets14219953over_wets
overwrote1557693overwrote
replots93412633_re_plots
underplots1345403underplots

Search took 7 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.1561145455.1
2DLD Change Limit1486411026.61022487.3
3Display Results1021020.0462217.4
 (SQL Overall)1786911026.81226231.8
 
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.