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

72 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
underfinanced206132(None) 
underpinned1544053underpin_n_ed
prefinanced1983184_pre_financed
refinanced16144764__re_financed
undefaced1644754unde_f__a_ced
undefinable1746384unde_finable_
undefined1445874unde_fi__n_ed
underfunded1763354underf__unded
underhanded1744664under__handed
underinsured1472054under_insured
underlined121610214underli__n_ed
undermanned1544184under__manned
undermined14189134undermi__n_ed
undersigned14114974undersi_gn_ed
ungerminated1653334ungermina_ted
cofinanced1843165___cofinanced
defiance1477635__de_fi_ance_
defiances1557035__de_fi_ances
financed1435115_____financed
indefinable1756355inde_finable_
indefinables1853125inde_finables
inheritance1654115inher_itance_
inheritances1753925inher_itances
interfaced1647945interf__a_ced
prefinance1795445_pre_finance_
prefinances1875015_pre_finances
refinance14117645__re_finance_
refinances15107135__re_finances
undedicated1654815unde_dica_ted
undefeated1546205unde_f_ea_ted
undefended1644005unde_f__ended
undefiled1446115unde_fi___led
underacted1449255under___acted
underaged121011235under___a_ged
underbaked1846175under__ba_ked
undercharged2073505under_charged
undercoated1546825under_coa_ted
undercounted1653255under_counted
underfed13311715underf_____ed
underfeed1448635underf____eed
underfund1445375underf__un__d
undergirded1544015undergi__rded
underhand1447265under__han__d
underheated1647015under_hea_ted
underinflated1852405under_inflated
underived14310515under_i___ved
underlapped1753695under__lapped
underline101714675underli__n_e_
underlines111512115underli__n_es
underlining1346685underlinin__g
underloaded1444505under_loa_ded
undermine122012235undermi__n_e_
undermines131710665undermi__n_es
undermining1546365underminin__g
underpinning1653425underpin_ning
underplayed1875025under_pla_yed
underpriced1744615under__priced
underrated12310845under__ra_ted
underreacted1653605under_reacted
undersized2148215undersi___zed
understaffed2052815under_staffed
understand1246185under_stan__d
understated1347835under_sta_ted
undertaxed1946515under__ta_xed
undertenant1284505undertenan__t
undertenants1362945undertenan_ts
undervalued1643795under__valued
undesignated1552835undesigna_ted
undrained1138525und_rai__n_ed
uneffaced1842575un_e_f_fa_ced
unrefined1345465unre_fi__n_ed
untenanted1144455unte___nanted

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 Limit124790729.21613540.6
3Display Results72720.0501440.0
 (SQL Overall)178691729.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.