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

(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
undershorts154369(None) 
undershirts1554121undershirts
undershoots1553451undershoots
underscores1445372underscores
undershirt1446452undershirt_
undershoot1445102undershoot_
undershot1346892undersho_t_
underskirts1653202underskirts
undercoats1346623under_coats
undercrofts17153303undercrofts
underheats1446053under_heats
underparts1346113under_parts
underplots1345403underplo_ts
underreports1571773underreports
underscore1345803underscor_e
underscored1545143underscored
undersets10129323unders__ets
undershirted1753473undershirted
undershrub16102683undersh_rub
undershrubs17102133undershrubs
underskirt1545023underskirt_
undersoils1156063unders_oils
undersongs1245333unders_ongs
understories1365563understories
understory1445123understor_y
underworks1845713under_works
bumbershoots219844bumbershoots
countershots1755934countersho_ts
dehorts11379774__de__horts
endorsors1044344endors_or_s
indorsors1043684indors_or_s
overshirts1644784_overshirts
overshoots1644394_overshoots
overshots1546624_oversho_ts
thunderstorms1961594thunderstorms
underacts1248584under__acts
underarms1246734under__arms
underboss1246434under_bo_ss
undercards1445564under_cards
undercharge1863864undercharge
undercharges1963634undercharges
undercoat1248734under_coat_
undercooks1744434under_cooks
undercools1344974under_cools
undercounts1444094undercounts
undercroft16154964undercroft_
undercuts1246644under__cuts
underdoes1139104under_do_es
underdogs1245754under_do_gs
underdoses1247004under_doses
undereats10310224under__eats
underflows1743944underflo_ws
underfoot1347034under_foot_
underfurs1355494under_fur_s
undergirds1344454under_girds
undergirt1147814under_girt_
undergods1246334under_go_ds
undergoers1245004under_goers
undergoes1139054under_go_es
undergrowth19142504undergrowth
undergrowths20151704undergrowths
underhairs1445454under_hairs
underhands1545454under_hands
underheat1348384under_heat_
underlets10158894under__lets
underloads1245234under_loads
undermost1247964under_most_
underpants1346914under_pants
underpart1288514under_part_
underplot1246824underplo_t_
underprops1554414underpro_ps
underreacts1453024underreacts
underreport1472914underreport_
underscoring1653634underscoring
underseas1087804unders__eas
undersells1144734unders_ells
underset91417134unders__et_
undershooting1852554undershooting
undersides1248694unders_ides
undersigns1265834unders_igns
undersoil1056774unders_o_il
undersold1146884unders_o_ld
undersong1147994unders_o_ng
underspins1346834unders_pins
understands1344654understands
understate1148864unders_tate
understates1247704understates
understeers1253764understeers
understood1244144understo_od
underthrust1552734underth_rust
underthrusts1651674underthrusts
undertints1148284under_tints
undertones1148974under_tones
undertows1366684under_to_ws
undervests1464744under_vests
undervote1357754under_vo_te
undervotes1456534under_votes
underwhelms20131714underwhelms
underwires1447024under_wires
underwoods1545714under_woods
underwools1444434under_wools
underwork1746424under_wor_k
underworld1544274under_world
underworlds1652804under_worlds
underwrote1445274underwro_te
unpersons1146854unpers_o_ns

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.436409841.7
2DLD Change Limit1488191068.95316622.2
3Display Results1061060.0631682.5
 (SQL Overall)1786911069.45218905.1
 
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.