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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

99 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
undershoots155345(None) 
undershoot1445101undershoot_
undershorts1543691undershorts
undershirts1554122undershirts
undershot1346892undersh_ot_
bumbershoots219843bumbershoots
overshoots1644393_overshoots
undercoats1346623under_coats
undercooks1744433under_cooks
undercools1344973under_cools
undercrofts17153303undercrofts
underfoot1347033under_foot_
underheats1446053under_heats
underplots1345403under_plots
underscores1445373underscores
undersets10129323unders__ets
undershirt1446453undershirt_
undershooting1852553undershooting
undershrubs17102133undershrubs
underskirts1653203underskirts
undersoils1156063unders_oils
undersongs1245333unders_ongs
understood1244143understoo_d
underwoods1545713under_woods
underwools1444433under_wools
bumbershoot2081344bumbershoot_
countershots1755934countersh_ots
overshoot1557134_overshoot_
overshots1546624_oversh_ots
reshoots11228414__re_shoots
tenderfoots1551684tender_foots
underacts1248584under__acts
underboss1246434under__boss
undercoat1248734under_coat_
undercook1644924under_coo_k
undercool1245534under_coo_l
undercounts1444094undercounts
undercroft16154964undercroft_
undercuts1246644under__cuts
underdoes1139104under__does
underdogs1245754under__dogs
underdoses1247004under_doses
undereats10310224under__eats
underflows1743944under_flows
undergods1246334under__gods
undergoers1245004under_goers
undergoes1139054under__goes
undergrowth19142504undergrowth
undergrowths20151704undergrowths
underhairs1445454under_hairs
underhands1545454under_hands
underheat1348384under_heat_
underlets10158894under__lets
underloads1245234under_loads
undermost1247964under_most_
underpants1346914under_pants
underparts1346114under_parts
underplot1246824under_plot_
underproof1643574underproo_f
underprops1554414under_props
underreacts1453024underreacts
underreports1571774underreports
underscore1345804unders_core
underscored1545144underscored
underseas1087804unders__eas
undersells1144734unders_ells
underset91417134unders__et_
undershirted1753474undershirted
undershrub16102684undersh_rub
undersides1248694unders_ides
undersigns1265834unders_igns
underskirt1545024underskirt_
undersoil1056774unders__oil
undersold1146884unders__old
undersong1147994unders__ong
underspins1346834unders_pins
understands1344654understands
understate1148864unders_tate
understates1247704understates
understeers1253764understeers
understories1365564understories
understory1445124unders_tory
underthrust1552734underthrust
underthrusts1651674underthrusts
undertints1148284under_tints
undertones1148974under_tones
undertook1445094under_too_k
undertows1366684under__tows
undervests1464744under_vests
undervote1357754under__vote
undervotes1456534under_votes
underwhelms20131714underwhelms
underwood1446474under_woo_d
underwool1345014under_woo_l
underworks1845714under_works
underwrote1445274under_wrote
unpersons1146854unpers__ons
unroots738564un__r__oots
upshoots1344234u___pshoots

Search took 10 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 Filter1786911488190.420425454.8
2DLD Change Limit148819999.36015899.5
3Display Results99990.0631571.4
 (SQL Overall)178691999.84318154.1
 
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.