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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

108 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
thirstinesses164258(None) 
thirstiness1442692thirstine_s_s
thriftinesses1952302thriftinesses
dirtinesses1239873_dir_tinesses
feistinesses1555883fei_stinesses
firstnesses1445733_first_nesses
hastinesses141210683_h_astinesses
hirsutenesses1653563_hirsutenesses
horsinesses1439533_hors_inesses
mistinesses131310603_mi_stinesses
shiftinesses18105243shi_ftinesses
tartinesses111011493t_ar_tinesses
tastinesses111110773t__astinesses
testinesses111210313t__estinesses
thorninesses1544393thor_ninesses
throatinesses1653263throatinesses
tipsinesses1336353t_ips_inesses
trustinesses12116943t_rustinesses
airinesses102613604_air__inesses
artinesses10815194__ar_tinesses
artsinesses1138704__artsinesses
bittinesses13148254_bi_ttinesses
bustinesses131310074__bustinesses
charinesses1639564char__inesses
chastenesses1746304ch_astenesses
chattinesses1755154ch_attinesses
cheesinesses1765374chees_inesses
chillinesses1744984chi_llinesses
crispinesses1645004cri_spinesses
crustinesses14137594_crustinesses
daintinesses1346244dai_ntinesses
ditsinesses12108754_dits_inesses
dustinesses121110334__dustinesses
fishinesses17107234_fi_shinesses
flightinesses2053134flightinesses
flimsinesses1743994flims_inesses
flintinesses1546324fli_ntinesses
friskinesses1944774fri_skinesses
frostinesses1546524_frostinesses
fustinesses14129764__fustinesses
ghastlinesses1742744gh_astlinesses
ghostlinesses1742494gh_ostlinesses
grislinesses1345824gri_slinesses
gristlinesses1443984gri_stlinesses
grittinesses1345834gri_ttinesses
guiltinesses1345094gui_ltinesses
gustinesses12139504__gustinesses
hairinesses14198944hair__inesses
hardinesses151110214_har_dinesses
harshnesses1745854_hars_hnesses
heartinesses1547994_heartinesses
heftinesses1737134_h_eftinesses
hillinesses1458504_hi_llinesses
hippinesses1845494_hi_ppinesses
horninesses1458994_hor_ninesses
huskinesses18136524_h_uskinesses
iratenesses11411404__iratenesses
lustinesses11910404__lustinesses
marshinesses1744964_marshinesses
mightinesses1844384_mightinesses
mirinesses121512304_mir__inesses
moistnesses1347144moi_st_nesses
mustinesses131010394__mustinesses
nastinesses111110724__nastinesses
niftinesses1437234_ni_ftinesses
noisinesses1139454noi_s_inesses
pastinesses13911704__pastinesses
priestlinesses1652704priestlinesses
prissinesses1355954pri_ssinesses
pursinesses1338724_purs_inesses
quirkinesses2542864quir_kinesses
riskinesses1537824_ri_skinesses
rustinesses11911524__rustinesses
shininesses1448294shi__ninesses
shirtdresses1651864shir_tdresses
shortnesses1446794shor_t_nesses
sissinesses9118304_si_ssinesses
sportinesses1447864spor_tinesses
tardinesses121110244t_ar_dinesses
tarrinesses11129084t_ar_rinesses
tartnesses101110714t_ar_t_nesses
tattinesses11128944t__attinesses
tearinesses11311694tear__inesses
tersenesses1149024t_ers_enesses
thicknesses2043904thi__cknesses
thingnesses1545174thi__ngnesses
thinnesses1346254thi___nnesses
thirstiest1343974thirsti_e_s_t
threadinesses1753334threadinesses
thriftiness1742474thriftine_s_s
tidinesses1139214t_i__dinesses
tightnesses1565584t_ight_nesses
timelinesses1445454t_imelinesses
tininesses10311154t_i__ninesses
tinninesses1136864t_i_nninesses
tirednesses1247734t_ir_ednesses
titanesses1037234t_i__tanesses
trashinesses1546114t_rashinesses
trickinesses1845214tri_ckinesses
tricksinesses1962434tricksinesses
tritenesses11710354t__ritenesses
weightinesses2052904weightinesses
whininesses1746184whi__ninesses
whitenesses1746634whi__tenesses
wirinesses131811514_wir__inesses
wispinesses1636264_wi_spinesses
wittinesses14127484_wi_ttinesses
yeastinesses1545564_yeastinesses

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 Filter178691950240.1231452772.4
2DLD Change Limit950241086.83013912.7
3Display Results1081080.126857.1
 (SQL Overall)1786911087.07925242.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.