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

74 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
undertakings189403(None) 
undertaking1796581undertaking_
underbaking1995162underbaking_
undertaxing20105582undertaxing_
undercoatings1753063undercoatings
undereating1369553undereating_
underlaying16125763underlaying_
underlings12178143under__lings
underpaying18125373underpaying_
underrating1388253underrating_
understaffings22121593understaffings
understandings17112373understandings
understating1446543understating_
undertaken1545983undertaken__
undertakers1643813undertak_ers
undertakes1547693undertak__es
undertints1148283undert__ints
underwings15146403under__wings
caretakings1852904care_takings
entertains1047624enterta_in_s
interfacings1854354interfacings
overtaking1878894_overtaking_
papermakings2352414papermakings
unbraking1636934un_br_aking_
uncertain1146204uncerta_in__
uncertainly1653224uncerta_inly
uncertainty1652854uncerta_inty
underacting1547524underacting_
underbakes1746364underbak__es
underbuying1843454underbuying_
undercoating1645374undercoating_
undercooking2063244undercooking_
underdoing1346804under_doing_
underdosing1444494underdosing_
undergoing1347084under_going_
underhairs1445454underha_i_rs
underhands1545454underha__nds
underheating1785134underheating_
underkills1543804under__kills
underlain1048684underla_in__
underlapping1853514underlapping_
underlines111512114under__lines
underling111514614under__ling_
underlining1346684underlining_
underloading1564294underloading_
underlying15136374under_lying_
undermines131710664under__mines
undermining1546364undermining_
underpaintings1862024underpaintings
underpants1346914underpa__nts
underpinnings1762014underpinnings
underpins1239734under__pin_s
underplaying19154354underplaying_
undersigns1265834under__signs
underskirts1653204under_skirts
undersongs1245334under__songs
underspins1346834under_spin_s
understaffing21102734understaffing_
understanding1673774understanding_
understands1344654understa__nds
undertake1448274undertak___e
undertaker1545784undertak__er
undertaxes1847024underta__xes
undertenants1362944undertenants
undertint10414864undert__in_t
undertones1148974undert__ones
undertricks1873014undert_ricks
underusing1247264under_using_
undervaluing1753384undervaluing_
underwing141410884under__wing_
underworking2153454underworking_
undeviating1644724undeviating_
undraping1337334und_r_aping_
undrawing1436904und_r_awing_

Search took 8 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.390458182.1
2DLD Change Limit124790746.90618069.8
3Display Results74740.0461608.7
 (SQL Overall)178691747.34224338.2
 
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.