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

103 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
overkill153553(None) 
overbill1337281overbill
overfill1436311overfill
overkills1644871overkills
overall10411082over_all
overbills1446602overbills
overcall1337672overcall
overchill1794212overchill
overfills1545702overfills
overfull1435922overfull
overgild1336582overgild
overgilt1239622overgilt
overkilled1844272overkilled
overkind1637952overkind
overmild1436982overmild
overmilk1735552overmilk
oversell1137472oversell
overspill1444412overspill
overwily1736662overwily
coverall1347603cover_all
jerkily2134623_jerkily
outkill1136553o_utkill
ovarial1037613ovar_ial
overable13513573overable
overalls11410393overalls
overbid132710273overbi_d
overbids14248903overbids
overbig13237543overbi_g
overbilled1645423overbilled
overbite13312083overbite
overboil1336913overboil
overboils1436623overboils
overbold14208553overbold
overbuild15154693overbuild
overbuilt1446483overbuilt
overcalls1447203overcalls
overchills1893483overchills
overcivil1743263overcivil
overcold14208493overcold
overcool1376783overcool
overdid12199173overdi_d
overfilled1745053overfilled
overfish1737893overfish
overfit132610963overfi_t
overfly16246883over_fly
overfoul1446223overfoul
overgilds1445183overgilds
overgird1336183overgird
overgirt1239123overgirt
overhaul1436223overhaul
overheld15197373overheld
overhigh1846363overhigh
overhold15219013overhold
overholy17216673overholy
overidle1248823overidle
overing111918053over_ing
overkeen15227103overkeen
overkilling1965063overkilling
overlie102615013overli_e
overlies112417043overlies
overlit102714743overli_t
overlive142211293overlive
overly122411363over__ly
overmelt13310713overmelt
overmilks1844453overmilks
overmine13313663overmine
overmix1935573overmi_x
overnice13310093overnice
overply15227653over_ply
overrich1648453overrich
override121512523override
overrife14169933overrife
overripe131410383overripe
overrule11149673overrule
oversale11313873oversale
oversalt11312743oversalt
oversells1236973oversells
oversick1736983oversick
overside122013933overside
oversize201812513oversize
overskirt1646213overskirt
overslip1336323overslip
oversold12218933oversold
oversoul1137093oversoul
overspills1543863overspills
overspilt1447403overspilt
overtalk1537073overtalk
overtime131312273overtime
overtip1238193overti_p
overtips1338353overtips
overtire111413113overtire
overtly13268983over_tly
overtoil1137453overtoil
overtoils1237083overtoils
overview1736333overview
overwide15179463overwide
overwind1538533overwind
overwise141810253overwise
overzeal2076093overzeal
perkily1637813_perkily
underkill1445073underkill
verbile1249863_verbile
verily122616053_ver_ily

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.420425454.8
2DLD Change Limit1461621037.12620511.1
3Display Results1031030.0462239.1
 (SQL Overall)1786911037.59223536.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.