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

112 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
oversells123697(None) 
oversell1137471oversell_
overalls11410392over_alls
overbills1446602overbills
overcalls1447202overcalls
overfills1545702overfills
overkills1644872overkills
overmelts1447262overmelts
oversales12313142oversales
oversalts1238162oversalts
overseas112612422overse_as
overseeds13248892overseeds
overseers12298782overseers
oversees112415902overse_es
oversets113114172overse_ts
oversews14289422overse_ws
oversouls1236602oversouls
overspills1543862overspills
overzeals2165762overzeals
aversely1444853averse_ly
coveralls1447083cover_alls
obversely1742823obverse_ly
obverses1335803obverse__s
operceles1344613operceles
outsells888653o_utsells
overall10411083over_all_
overbears14208483overbears
overbeats14279823overbeats
overbets132510683overbe_ts
overbill1337283overbill_
overboils1436623overboils
overcall1337673overcall_
overchills1893483overchills
overcools1476773overcools
overdecks1944573overdecks
overeats112415263over_eats
overfears15236943overfears
overfeeds16226023overfeeds
overfill1436313overfill_
overfull1435923overfull_
overgilds1445183overgilds
overhauls1545513overhauls
overheads16248933overheads
overheaps17226953overheaps
overhears15258873overhears
overheats15229993overheats
overheld15197373overhe_ld
overholds16206333overholds
overkill1535533overkill_
overleaps14226783overleaps
overlends13237523overlends
overlets112312363overle_ts
overmelt13310713overme_lt
overmilks1844453overmilks
overpedals1643433overpedals
overplus1336063over_plus
overrules12129093overrules
oversale11313873overs_ale
oversalt11312743overs_alt
oversaves15310183oversaves
overscale1447993overscale
oversea102412113overse__a
oversee102717603overse__e
overseed122513353overse_ed
overseen112612173overse_en
overseer112611073overse_er
overselling1547793overselling
overset102821473overse__t
oversew132810833overse__w
oversewed1636943oversewed
oversewn14266933overse_wn
oversexed2037223oversexed
overshoes1538863overshoes
overshots1546623overshots
oversides131512663oversides
oversizes211111613oversizes
oversleep1445433oversleep
oversleeps1553253oversleeps
overslept1446853overslept
overslip1336323overs_lip
overslips1446763overslips
overslow1435693overs_low
oversoaks1635983oversoaks
oversold12218933overs_old
oversoul1137093oversoul_
overspends1644443overspends
overspill1444413overspill
overspilt1447403overspilt
overspins1439043overspins
overstays1535943overstays
oversteers1344863oversteers
oversteps1436303oversteps
overstirs1238213overstirs
oversuds1237033overs_uds
oversups1336553overs_ups
overtalks1645663overtalks
overtoils1237083overtoils
overuses11312643overuse__s
overwears15227873overwears
overweens15247003overweens
overwets14219953overwe_ts
overwhelms2142133overwhelms
overzeal2076093overzeal_
presells1058283pre_sells
resells73313203_re_sells
supersells1246463supersells
undersells1144733undersells
vermeils1374813_vermeils
versers103813523_verse_rs
verses94223763_verse__s
versets103913103_verse_ts
vessels1035933_vesse_ls

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.420425454.8
2DLD Change Limit1486411127.48619855.9
3Display Results1121120.0462434.8
 (SQL Overall)1786911127.95222471.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.