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

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

100 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
undergarments176280(None) 
undergarment1653641undergarment_
underlayments1972642underlayments
underpayments2162502underpayments
endearments14115383ende__arments
overgarments18133673_overgarments
undercurrents1692023undercurrents
underlayment1853403underlayment_
underpayment2063213underpayment_
debarments1545854__de_barments
endangerments1772474endangerments
endearment13106964ende__arment_
kindergartens1981534kindergarten_s
overgarment17135134_overgarment_
underarms1246734under_arm___s
undercurrent1573014undercurrent_
undergrounds1551974underg_rounds
underpants1346914underpa___nts
underparts1346114underpar___ts
understatements1881674understatements
debarment1447795__de_barment_
deferments16128585__de_ferments
departments1645795__de_partments
derailments1446105__derailments
determents131010315__de_terments
disbarments1654935__disbarments
endangerment1673015endangerment_
endorsements1555495endor_sements
energumens1352795en_erg_umen_s
engorgements1694665engorg_ements
enlargements1555195enlarg_ements
enserfments1654685enser__fments
entertainments1672455entertainments
entrapments1546295en_tr_apments
entreatments14114395en_treatments
fundaments1653865fund___a_ments
garments1139965_____garments
indorsements1565185indor_sements
integuments1454565inte_g_uments
interlacements1862665interlacements
interments12716215inte___rments
internments13510285inter__nments
inveiglements1962415inveiglements
kindergarten1881525kindergarten__
kindergartener2071275kindergartener
kindergarteners2181395kindergarteners
kindergartners2071115kindergartners
overpayments2253495_overpayments
subdepartments2181165subde_partments
undecadent1453575unde_ca_dent_
underacts1248585under_a___cts
underages11811085under_a_ge__s
underarm1147845under_arm____
underbakes1746365underba_ke__s
undercards1445565undercar___ds
undercharges1963635undercharge__s
undercounts1444095under__counts
undercrofts17153305under_cr_ofts
underdrawers1751715underdrawe_rs
undereaten1149545underea_ten__
undereats10310225unde___r_eats
undergirded1544015undergirde__d
undergirding1653325undergirdin_g
undergirds1344455undergir___ds
undergirt1147815undergir___t_
underglazes2243905underglaze__s
undergoers1245005underg__oe_rs
undergoes1139055underg__oe__s
undergrads1344795underg_r__ads
undergraduate1671325undergraduate
undergraduates1761175undergraduates
underground1452785underg_roun_d
undergrowth19142505underg_r_owth
undergrowths20151705underg_rowths
underhands1545455underha___nds
underheats1446055unde___rheats
underlets10158895unde___rle_ts
undermines131710665unde___rmines
underpart1288515underpar___t_
underpasses1444665underpasse__s
underrates11410565underra_te__s
underreacts1453025under__reacts
underruns1066735under__r_un_s
undersets10129325unde___rse_ts
understatement1772325understatement_
understrength1861455understr_ength
undertaken1545985underta_ken__
undertakers1643815underta_ke_rs
undertakes1547695underta_ke__s
undertakings1894035underta_kings
undertaxes1847025underta_xe__s
undertenants1362945under_tenants
underthrusts1651675underthr_usts
undertints1148285unde___rtints
undervalues1544155undervalue__s
undervests1464745unde___rvests
underwent1349055unde___rwent_
underwires1447025underwir_e__s
unsettlements1562745unsettlements
wonderments1754515wonde___rments

Search took 9 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 Filter1786911247900.376475242.0
2DLD Change Limit1247901007.92015756.3
3Display Results1001000.0631587.3
 (SQL Overall)1786911008.35921377.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.