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

106 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
overboils143662(None) 
overboil1336911overboil_
overtoils1237081overtoils
overbids14248902overb_ids
overbill1337282overb_ill
overbills1446602overbills
overboiled1646132overboiled
overbold14208552overbo_ld
overbooks1855872overbooks
overbuild15154692overbuild
overbuilds1642972overbuilds
overbuilt1446482overbuilt
overcools1476772overcools
oversouls1236602oversouls
overtoil1137452overtoil_
garboils1145663_garboils
gerbils1037303_gerb_ils
overalls11410393over_alls
overbakes18129133overbakes
overbears14208483overbears
overbeats14279823overbeats
overbets132510683overb_ets
overbid132710273overb_i_d
overbig13237543overb_i_g
overbite13312083overb_ite
overbites14310983overbites
overblows1745003overblows
overboard1537813overboard
overboiling1746843overboiling
overbook1796323overbo_ok
overbore131111583overbo_re
overborn13128703overbo_rn
overborne14128023overborne
overbrief1757213overbrief
overbriefs1843653overbriefs
overburns14135613overburns
overbuys1644833overb_uys
overcalls1447203overcalls
overchill1794213overchill
overchills1893483overchills
overcoats1438863overcoats
overcold14208493overco_ld
overcomes161110333overcomes
overcooks1875763overcooks
overcool1376783overcool_
overdoers13117403overdoers
overdoes121212543overdo_es
overdogs13127493overdo_gs
overdoing1439143overdoing
overdoses13119793overdoses
overdries13310883overdries
overedits1346813overedits
overfill1436313over_fill
overfills1545703overfills
overflies1539103overflies
overfocus1744263overfocus
overfoul1446223overfoul_
overgild1336583over_gild
overgilds1445183over_gilds
overgilt1239623over_gilt
overgoads14115893overgoads
overhauls1545513overhauls
overhold15219013overho_ld
overholds16206333overholds
overholy17216673overho_ly
overhopes1738143overhopes
overjoys2135183overjo_ys
overkill1535533over_kill
overkills1644873overkills
overlies112417043over_lies
overloads13127663overloads
overlooks1685483overlooks
overlords13117223overlords
overloves15218673overloves
overmild1436983over_mild
overmilk1735553over_milk
overmilks1844453over_milks
overplies14310463overplies
oversells1236973oversells
overslips1446763overslips
oversoaks1635983oversoaks
oversold12218933overso_ld
oversoul1137093oversoul_
overspill1444413overspill
overspills1543863overspills
overspilt1447403overspilt
overspins1439043overspins
overstirs1238213overstirs
overtips1338353over_tips
overtoiled1446293overtoiled
overtones121011853overtones
overtops1338513overto_ps
overtrims1447503overtrims
overvotes1538423overvotes
overwily1736663over_wily
overwords16127643overwords
overworks19127393overworks
overzeals2165763overzeals
parboils1237433_parboils
preboils1267293pre_boils
reboils94111723_re_boils
verbals121910743_verb_als
verbids13259203_verb_ids
verbile1249863_verb_ile
verbiles1338923_verb_iles
vermeils1374813_vermeils

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.423422437.4
2DLD Change Limit1486411066.57622603.6
3Display Results1061060.0462304.3
 (SQL Overall)1786911067.04525364.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.