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

115 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
overfill143631(None) 
overbill1337281overbill
overfills1545701overfills
overfull1435921overfull
overkill1535531overkill
overall10411082over_all
overbills1446602overbills
overcall1337672overcall
overchill1794212overchill
overfilled1745052overfilled
overfish1737892overfish
overfit132610962overfi_t
overfly16246882overf_ly
overfoul1446222overfoul
overgild1336582overgild
overgilt1239622overgilt
overkills1644872overkills
overmild1436982overmild
overmilk1735552overmilk
oversell1137472oversell
overspill1444412overspill
overwily1736662overwily
coverall1347603cover_all
evenfall1492943evenfall
fiberfill1751753fiberfill
hoverfly2043003hoverf_ly
ovarial1037613ovar_ial
overable13513573overable
overalls11410393overalls
overbid132710273overbi_d
overbids14248903overbids
overbig13237543overbi_g
overbilled1645423overbilled
overbite13312083overbite
overboil1336913overboil
overboils1436623overboils
overbold14208553overbold
overbuild15154693overbuild
overbuilt1446483overbuilt
overcalls1447203overcalls
overchills1893483overchills
overcivil1743263overcivil
overcold14208493overcold
overcool1376783overcool
overdid12199173overdi_d
overfacile1844913overfacile
overfar13227943overf_ar
overfast14249663overfast
overfat132712283overf_at
overfear14247403overfear
overfed142510253overf_ed
overfeed15299443overfeed
overfilling1885643overfilling
overflew1735593overflew
overflies1539103overflies
overflow1754923overflow
overfond1537323overfond
overfree1439003overfree
overfulfill2051143overfulfill
overfund1535813overfund
overgilds1445183overgilds
overgird1336183overgird
overgirt1239123overgirt
overhaul1436223overhaul
overheld15197373overheld
overhigh1846363overhigh
overhold15219013overhold
overholy17216673overholy
overidle1248823overidle
overing111918053over_ing
overkilled1844273overkilled
overkind1637953overkind
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
overslip1336323overslip
oversold12218933oversold
oversoul1137093oversoul
overspills1543863overspills
overspilt1447403overspilt
overtalk1537073overtalk
overtime131312273overtime
overtip1238193overti_p
overtips1338353overtips
overtire111413113overtire
overtly13268983over_tly
overtoil1137453overtoil
overtoils1237083overtoils
overview1736333overview
overwide15179463overwide
overwind1538533overwind
overwise141810253overwise
overzeal2076093overzeal
refill94514053_re_fill
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.1701051123.5
2DLD Change Limit1461621157.59619242.0
3Display Results1151150.0462500.0
 (SQL Overall)1786911157.81222873.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.