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

84 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
prefinanced198318(None) 
prefinance1795441prefinance_
prefinances1875011prefinances
refinanced16144761_refinanced
refinance14117642_refinance_
refinances15107132_refinances
cofinanced1843163_cofinanced
financed1435113___financed
penanced1338163p_e__nanced
prefaced1638423pref__a_ced
prefinancing2051943prefinancing
prefranked2042773pref_ranked
affianced1843034_affi_anced
cofinance1645554_cofinance_
cofinances1745304_cofinances
defiance1477634_defi_ance_
defiances1557034_defi_ances
finance1238574___finance_
finances1338654___finances
freelanced1643274fre_elanced
ordinance1245054or_dinance_
ordinances1344974or_dinances
penance11313444p_e__nance_
penances12312444p_e__nances
pertinence1445834pertinence_
pertinences1545744pertinences
pranced123714044pr____anced
preannounced1761354preannounced
prearranged1552704prearranged
precancel1546204pre__cancel
precancer1547094pre__cancer
precleaned1543804preclean_ed
predicated1649144predica_ted
predinner1245134predin_n_er
predominance1983524predominance_
predominances2093294predominances
preeminence1763804preeminence_
preeminences1883524preeminences
preenacted1544974pre_enacted
prefabbed1942324pref__abbed
preface14510924pref__a_ce_
prefacer1537984pref__a_cer
prefaces15311064pref__a_ces
prefaded1537824pref__a_ded
preference1776984preference_
preferences1876184preferences
prefigured1743314prefi_gured
prefiled143310574prefi___led
prefilled1535514prefi__lled
prefired144310754prefi___red
prefixed21357704prefi___xed
prefunded1644694pref__unded
pregnancies1644564pre_gnancies
pregnancy1744064pre_gnanc_y
preinvited1663924pre_invited
prenticed14118064pre__nticed
preplaced1676484pre_pla_ced
preplanned1543504pre_planned
prerinsed1246324preri__nsed
presentenced1754044presentenced
presignaled1552384presigna_led
presignalled1651444presignalled
profaned14207974prof__an_ed
prominence1644924prominence_
prominences1744864prominences
provenance1744494provenance_
provenances1854534provenances
rebalanced1543584_rebalanced
refaced133713574_ref__a_ced
refenced1438994_ref__enced
referenced1676864_referenced
refinable1438624_refinable_
refinancing1742834_refinancing
refined114720004_refi__n_ed
refinished1744084_refinished
reinduced1374594_re_induced
reliance10310474_reli_ance_
reliances1139624_reli_ances
reminisced1544284_reminisced
repinned1157474_repin_n_ed
resinated10413284_resina_ted
resonance1147624_resonance_
resonances1246874_resonances
underfinanced2061324underfinanced

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 Limit148819848.65617192.6
3Display Results84840.0461826.1
 (SQL Overall)178691849.12519582.6
 
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.