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

66 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
undercurrents169202(None) 
undercurrent1573011undercurrent_
countercurrents1962333countercurrents
intercurrent1454353intercurrent_
supercurrents17113473supercurrents
undergarments1762803undergarments
countercurrent1863464countercurrent_
decurrent1256454__de_current_
supercurrent16114454supercurrent_
uncurrent1145674un___current_
undercounts1444094underc__ounts
undercrofts17153304underc__rofts
undercuts1246644undercu____ts
undergarment1653644undergarment_
underlayments1972644underlayments
underpayments2162504underpayments
concurrents1554565__concurrents
crosscurrents1761035crosscurrents
currents1038375_____currents
deterrents11126475__de_terrents
endearments14115385ende__arments
excurrent1844045___excurrent_
incurrent1147125in___current_
noncurrent1255515_n_oncurrent_
nonrecurrent1462965_nonrecurrent_
occurrents1453005___occurrents
overcorrects19153005_overcorrects
photocurrents2072135photocurrents
recurrent1146715__re_current_
undecadent1453575unde_c_adent_
undercards1445565underc_ar__ds
undercarriage1761435undercarriage
undercarriages1861245undercarriages
undercharges1963635underchar_ges
undercoatings1753065undercoatings
undercoats1346625underc___oats
undercount1346385underc__ount_
undercroft16154965underc__roft_
undercut1148665undercu____t_
undercutting1653765undercuttin_g
undereats10310225unde____reats
underfunds1544035underfu___nds
underfurs1355495underfu_r___s
undergrounds1551975under_grounds
underheats1446055unde___rheats
underlayment1853405underlayment_
underlets10158895unde___rle_ts
underpants1346915unde___rpants
underparts1346115under_par__ts
underpayment2063215underpayment_
underreacts1453025under__reacts
underruns1066735unde___rrun_s
underscores1445375underscore__s
undersets10129325unde___rse_ts
undershirts1554125undershir__ts
undershorts1543695undershor__ts
underskirts1653205underskir__ts
understrength1861455under_strength
undersurfaces1961545undersurfaces
undertenants1362945under_tenants
underthrusts1651675under_thrusts
undertints1148285unde___rtints
underuses1039915under_u_se__s
undervests1464745unde___rvests
underwent1349055unde___rwent_
underwires1447025under_wire__s

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 Filter1786911247900.393454684.5
2DLD Change Limit124790669.21613540.6
3Display Results66660.0501320.0
 (SQL Overall)178691669.65918499.9
 
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.