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

97 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
undershirts155412(None) 
undershirt1446451undershirt_
undershorts1543691undershorts
underskirts1653201underskirts
undershirted1753472undershirted
undershoots1553452undershoots
underskirt1545022underskirt_
overshirts1644783_overshirts
undergirds1344453under_girds
undergirt1147813under_girt_
underhairs1445453underhair_s
underheats1446053under_heats
underparts1346113under_parts
underscores1445373underscores
undersets10129323unders__ets
undershoot1445103undershoot_
undershot1346893undersh_ot_
undershrub16102683undersh_rub
undershrubs17102133undershrubs
undersides1248693unders_ides
undersigns1265833unders_igns
undersoils1156063undersoi_ls
underspins1346833underspi_ns
undertints1148283under_tints
underwires1447023under_wires
elderships1654454eldershi_ps
overshirt1547904_overshirt_
overskirts1743714_overskirts
redshirts1342904__redshirts
riderships1655084ridershi_ps
underacts1248584under__acts
underarms1246734under__arms
underbids13137244under_bi_ds
underbite1249814under_bi_te
underbites1347894under_bites
underbrims1544064underbri_ms
undercards1445564under_cards
undercharge1863864undercharge
undercharges1963634undercharges
undercoats1346624under_coats
undercounts1444094undercounts
undercrofts17153304undercrofts
undercuts1246644under__cuts
undereats10310224under__eats
underfurs1355494under_fur_s
undergird1245904under_gir_d
undergoers1245004undergoer_s
underhair1345734underhair__
underhands1545454under_hands
underheat1348384under_heat_
underkills1543804under_kills
underlets10158894under__lets
underlies101414204under_li_es
underlines111512114under_lines
underlings12178144under_lings
underlips12147674under_li_ps
underlit91311534under_li_t_
undermines131710664under_mines
underpants1346914under_pants
underpart1288514under_part_
underpins1239734under_pi_ns
underplots1345404under_plots
underprices1644724underprices
underreacts1453024underreacts
underreports1571774underreports
underscore1345804underscor_e
underscored1545144underscored
underseas1087804unders__eas
undersells1144734unders_ells
underset91417134unders__et_
underside11310144unders_i_de
undersign1177114unders_i_gn
undersize1949514unders_i_ze
undersized2148214unders_ized
undersoil1056774undersoi__l
undersongs1245334unders_ongs
underspin1246654underspi__n
understands1344654understands
understate1148864unders_tate
understates1247704understates
understeers1253764understeers
understories1365564understories
understory1445124understor_y
underthrust1552734underth_rust
underthrusts1651674underthrusts
undertint10414864under_tint_
undertricks1873014undertricks
undervests1464744under_vests
underweights2052354underweights
underwhelms20131714underwhelms
underwings15146404under_wings
underwire1348124under_wir_e
underworks1845714under_works
underwrite1446314underwri_te
underwrites1545184underwrites
undesired1147524unde_s_ired
unshifts1444034un___shifts

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.423422437.4
2DLD Change Limit148819979.03016480.5
3Display Results97970.0631539.7
 (SQL Overall)178691979.51618778.0
 
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.