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

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

139 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
idiomaticnesses2071051idiomaticnesses_
idiomaticness1861093idiomaticne_s_s_
animatenesses1555946ani_mat_enesses_
dirtinesses1239886_di__rti_nesses_
dismalnesses1553986_disma__lnesses_
dottinesses1238136_d_o_tti_nesses_
exoticnesses2142686_exo__ticnesses_
imitativenesses2084496imi_tativenesses_
intimatenesses1655026intimat_enesses_
inviolatenesses1892806inviolat_enesses_
matinesses12314546____mati_nesses_
throatinesses1653276thro_ati_nesses_
visionarinesses1861666visionari_nesses_
adequatenesses2462637adequat_enesses_
adorablenesses1755447ad_orablenesses_
adroitnesses1344137adro___itnesses_
amativenesses1856787___amativenesses_
bittinesses13148267_bi__tti_nesses_
combativenesses2464157__combativenesses_
comelinesses1666407__comeli_nesses_
comfinesses1846917__com_fi_nesses_
customarinesses1961307customari_nesses_
daintinesses1346247_d_ainti_nesses_
datednesses1357907_d___atednesses_
debonairnesses1771447debona_irnesses_
desolatenesses1553977desolat_enesses_
diakineses1543697_di__aki_ne_ses_
dilatorinesses1552057_di_latorinesses_
dilutenesses1346117_di_lut_enesses_
dimnesses1238217_di_m____nesses_
dinginesses1337477_di__ngi_nesses_
dippinesses1635247_di__ppi_nesses_
directednesses1863387_directednesses_
directnesses1595287_direct__nesses_
distantnesses1453837_dista_ntnesses_
distinctnesses1752567_di__stinctnesses_
ditsinesses12108767_di___tsinesses_
ditzinesses21126217_di___tzinesses_
dizzinesses20124027_di__zzi_nesses_
dodginesses1435437_d_o_dgi_nesses_
doltishnesses1744617_d_o_ltishnesses_
dopinesses13159727_d_o__pi_nesses_
dorkinesses1647667_d_o_rki_nesses_
doughtinesses1852557_doughti_nesses_
dowdinesses1635727_d_o_wdi_nesses_
downinesses1536147_d_o_wni_nesses_
dozinesses20168637_d_o__zi_nesses_
draftinesses1645757_d_rafti_nesses_
dreaminesses1545717_d_reami_nesses_
drearinesses1347447_d_reari_nesses_
droughtinesses1951837_droughti_nesses_
drowsinesses1644387_dro_wsi_nesses_
dumpinesses16126257_d_um_pi_nesses_
dustinesses121110357_d__usti_nesses_
educatednesses1852837ed_ucatednesses_
educationeses1661547ed_ucatione_ses_
emptinesses1545997___empti_nesses_
evocativenesses2364347_evocativenesses_
feistinesses1555897fei__sti_nesses_
fidgetinesses1851887_fidgeti_nesses_
filminesses1636237_film__i_nesses_
flightinesses2053137fli_ghti_nesses_
flimsinesses1743997fli_m_si_nesses_
flintinesses1546327fli__nti_nesses_
foaminesses1658077__fo_ami_nesses_
franticnesses1843677__franticnesses_
frostinesses1546537_fro_sti_nesses_
gloominesses1544127gloom__i_nesses_
goutinesses1239977__go_uti_nesses_
griminesses14167557gri_m__i_nesses_
grittinesses1345847gri__tti_nesses_
guiltinesses1345117gui__lti_nesses_
hoarinesses14310227__ho_ari_nesses_
homelinesses1765367__homeli_nesses_
homesicknesses2561597__homesicknesses_
hominesses15510867__hom__i_nesses_
identicalnesses1882427id__enticalnesses_
idiomatic1446027idiomatic_______
idiomatically2155557idiomatic___ally
ignorantnesses1562217ignora_ntnesses_
immovablenesses2493807immovablenesses_
impolitenesses1853957impolit_enesses_
inanimatenesses1762747inanimat_enesses_
inchoatenesses1953597inchoat_enesses_
indirectnesses1762167indirect__nesses_
inhumannesses1852177inhuma__nnesses_
initialnesses1395617ini___tialnesses_
innatenesses1247187__innat_enesses_
iratenesses11411447__i_rat_enesses_
knottinesses1643917_kno_tti_nesses_
liminesses121310857_li_m__i_nesses_
limitednesses1654017_li_mitednesses_
limpidnesses1743627_li_m_pidnesses_
loaminesses1358457__lo_ami_nesses_
loathnesses1445867__lo_at_hnesses_
loftinesses1437927__lo_fti_nesses_
maltinesses13310237____malti_nesses_
mateynesses1645177____mateynesses_
mazinesses2139927____mazi_nesses_
meatinesses13311987___meati_nesses_
mightinesses1844387_mi_ghti_nesses_
mistinesses131310627_mi__sti_nesses_
niftinesses1437247_ni__fti_nesses_
normativenesses2084527_normativenesses_
odiousnesses1347997odio___usnesses_
ordinarinesses1552357ordi_nari_nesses_
pottinesses1339107__po_tti_nesses_
primitivenesses2263947pri_mitivenesses_
privatenesses1855347pri_vat_enesses_
prolificnesses2151167_prolificnesses_
promotivenesses22113897_promotivenesses_
promptnesses1843637_prompt__nesses_
riminesses121211417_ri_m__i_nesses_
roominesses1337437_room__i_nesses_
rootinesses1139527__ro_oti_nesses_
shiftinesses18105247shi__fti_nesses_
skimpinesses2043187ski_m_pi_nesses_
slatinesses11311637___slati_nesses_
sliminesses1338097sli_m__i_nesses_
snootinesses1265807_sno_oti_nesses_
snottinesses1255847_sno_tti_nesses_
soapinesses1339717__so_api_nesses_
sootinesses11410057__so_oti_nesses_
sportinesses1447877_spo_rti_nesses_
spottinesses1445687_spo_tti_nesses_
sweatinesses1546917__sweati_nesses_
thirstinesses1642587thi_rsti_nesses_
timelinesses1445457_ti_meli_nesses_
timidnesses1445147_ti_m__idnesses_
ultimatenesses1652997ultimat_enesses_
villainesses1543517_villa_i_nesses_
violablenesses1984737_violablenesses_
volatilenesses1754477__volatilenesses_
weightinesses2052907wei_ghti_nesses_
wimpinesses1835637_wi_m_pi_nesses_
wittinesses14127487_wi__tti_nesses_
womanishnesses2252827__womanishnesses_
womanlinesses1843147__womanlinesses_
womannesses1644397__woma__nnesses_

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.360496363.9
2DLD Change Limit950241398.51311162.2
3Display Results1391390.1101263.6
 (SQL Overall)1786911398.98319892.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.