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

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

77 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
faultinesses154518(None) 
fattinesses14118972fa_ttinesses
faultiness1344822faultine_s_s
fruitinesses1546442fruitinesses
fustinesses14129782f_ustinesses
jauntinesses1944682jauntinesses
maltinesses13310232ma_ltinesses
saltinesses11311452sa_ltinesses
adultnesses1244833adult_nesses
artinesses10815213_a_rtinesses
balkinesses1767503ba_lkinesses
balminesses1537253ba_lminesses
battinesses13169453ba_ttinesses
bulginesses1466133_bulginesses
bulkinesses1786483_bulkinesses
bustinesses131310093_bustinesses
cattinesses13129703ca_ttinesses
crustinesses14137633crustinesses
dailinesses1249493dail_inesses
daintinesses1346243daintinesses
dustinesses121110353_dustinesses
earlinesses11311043earl_inesses
faintnesses1447143faint_nesses
fallownesses1852373fallownesses
falsenesses1446743fa_lsenesses
fancinesses1638143fa_ncinesses
fastnesses1389083fa_st_nesses
fatnesses121710463fa__t_nesses
feistinesses1555893feistinesses
filminesses1636233f_ilminesses
filthinesses1844463f_ilthinesses
flintinesses1546323flintinesses
fluffinesses1742663fluffinesses
flukinesses1836093flu_kinesses
foulnesses1337933foul__nesses
frostinesses1546533frostinesses
fullnesses1336213f_ul_lnesses
fulnesses1239053f_ul__nesses
funkinesses18137003f_unkinesses
funninesses14106873f_unninesses
furrinesses1437183f_urrinesses
fussinesses13126943f_ussinesses
fuzzinesses2243723f_uzzinesses
gaudinesses1337853gau_dinesses
gauntnesses1245173gaunt_nesses
gauzinesses2136043gau_zinesses
goutinesses1239973gou_tinesses
guiltinesses1345113guiltinesses
gustinesses12139523_gustinesses
hastinesses141210693ha_stinesses
haughtinesses2042163haughtinesses
lustinesses11910423_lustinesses
manlinesses13910193manl_inesses
matinesses12314543ma__tinesses
mustinesses131010413_mustinesses
nastinesses111110743na_stinesses
nattinesses11119323na_ttinesses
naughtinesses1752413naughtinesses
nuttinesses11117753_nuttinesses
paltrinesses1445513pa_ltrinesses
pastinesses13911713pa_stinesses
pulpinesses1536003_pulpinesses
runtinesses111210963_runtinesses
rustinesses11911553_rustinesses
ruttinesses11128993_ruttinesses
saltnesses10310163sa_lt_nesses
saucinesses1338983sau_cinesses
smuttinesses14135083smuttinesses
sulkinesses1557723_sulkinesses
sultanesses1145563_sultanesses
sultrinesses1245883_sultrinesses
talkinesses1537353ta_lkinesses
tartinesses111011503ta_rtinesses
tastinesses111110783ta_stinesses
tattinesses11128943ta_ttinesses
tautnesses10118283tau_t_nesses
trustinesses12116983trustinesses

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 Filter178691950240.373479064.3
2DLD Change Limit95024777.61012486.7
3Display Results77770.376204.8
 (SQL Overall)178691778.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.