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

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

182 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
dwarfishnesses249213(None) 
dwarfishness2292022dwarfishne_s_s
bearishnesses1844843bear_ishnesses
dwarfnesses1843293dwarf___nesses
garishnesses1645883_gar_ishnesses
oafishnesses1844773_oa_fishnesses
raffishnesses2243223_raffishnesses
swainishnesses1952323swainishnesses
waggishnesses2143283_waggishnesses
waspishnesses2043283_waspishnesses
wolfishnesses2243733_wolfishnesses
apishnesses1646374__a_pishnesses
boorishnesses1864314boor_ishnesses
brackishnesses2552644brackishnesses
caddishnesses2043374_caddishnesses
churlishnesses2252544churlishnesses
clannishnesses1952984clannishnesses
daffinesses1834844d_affi__nesses
daringnesses1464834d_ar_ingnesses
darlingnesses1563044d_arlingnesses
devilishnesses2152694devilishnesses
doggishnesses19143684d_oggishnesses
dollishnesses1744374d_ollishnesses
doltishnesses1744614d_oltishnesses
donnishnesses1784114d_onnishnesses
dovishnesses1944464d__ovishnesses
faddishnesses2143244_faddishnesses
gawkishnesses2443034_gawkishnesses
girlishnesses1744034_girlishnesses
harshnesses1745854_har__shnesses
hawkishnesses2643254_hawkishnesses
lavishnesses1844774_la_vishnesses
mannishnesses1873964_mannishnesses
mawkishnesses2543134_mawkishnesses
offishnesses2143814__offishnesses
owlishnesses1844644ow__lishnesses
prankishnesses2353204prankishnesses
qualmishnesses2852084qualmishnesses
rakishnesses1944994_ra_kishnesses
selfishnesses1844044_selfishnesses
slavishnesses1843684sla_vishnesses
snappishnesses2052264snappishnesses
sniffishnesses2272204sniffishnesses
squarishnesses2552444squar_ishnesses
swinishnesses1843654sw_inishnesses
warinesses131514524_war_i__nesses
waterishnesses2053164_waterishnesses
wimpishnesses2343584_wimpishnesses
archnesses1547175__ar__chnesses
aridnesses1139935__ar_i_dnesses
artinesses10815215__arti__nesses
artsinesses1138715__ar_tsinesses
awarenesses1447255awar___enesses
bearishness1644545bear_ishne_s_s
blimpishnesses2382145blimpishnesses
bluishnesses1765265__bluishnesses
bookishnesses2263685_bookishnesses
boyishnesses2044035__boyishnesses
brashnesses1646555__br_ashnesses
brisknesses1745585__br_isknesses
brutishnesses1844095_brutishnesses
bullishnesses1844045_bullishnesses
charinesses1639565char_i__nesses
childishnesses2352565childishnesses
cliquishnesses2852115cliquishnesses
cloddishnesses2152625cloddishnesses
clownishnesses2262275clownishnesses
coarsenesses1447245coar__senesses
coltishnesses1845225_coltishnesses
crispnesses1545945__cr_ispnesses
cultishnesses1844565_cultishnesses
daftnesses1436385d_a_f__tnesses
dailinesses1249495d_a__ilinesses
dailynesses1543945d_a__ilynesses
darknesses1537015d_ar___knesses
deadlinesses1446225deadli__nesses
deafnesses1436225dea_f___nesses
dearnesses1139585dear____nesses
diffusenesses2052825d_iffusenesses
dirtinesses1239885d_irti__nesses
dorkinesses1647665d_orki__nesses
downrightnesses238925downr_ightnesses
draftinesses1645755dra_f_tinesses
drearinesses1347445drear_i__nesses
dressinesses1245525d__ressinesses
drowsinesses1644385d__rowsinesses
dwarfness1642795dwarf___ne_s_s
earlinesses11311045_earli__nesses
earnestnesses1353665_earnestnesses
earwitnesses1543785_earwi_tnesses
faintishnesses2053305faintishnesses
fearfulnesses1945315fearf_ulnesses
fearlessnesses1666745fearlessnesses
feverishnesses2382885feverishnesses
fiendishnesses2172475fiendishnesses
fishinesses17107245____fishinesses
folkishnesses2343925_folkishnesses
foolishnesses1944465_foolishnesses
foppishnesses2343395_foppishnesses
freakishnesses2452655freakishnesses
freshnesses1746105__fr_eshnesses
garishness1445745_gar_ishne_s_s
ghoulishnesses2152285ghoulishnesses
glarinesses1239515glar_i__nesses
glaringnesses1553395glar_ingnesses
greenishnesses1882965greenishnesses
hardinesses151110215_hardi__nesses
heartinesses1548005hearti__nesses
hellishnesses1974355_hellishnesses
hoarinesses14310225hoar_i__nesses
hoarsenesses1545605hoar__senesses
hoggishnesses21143655_hoggishnesses
impishnesses1944295__impishnesses
larkinesses1538995_larki__nesses
leafinesses1437875lea_fi__nesses
liverishnesses2063025liverishnesses
loutishnesses1644995_loutishnesses
lumpishnesses2043475_lumpishnesses
marshinesses1744965_mar__shinesses
modishnesses1844735__modishnesses
mulishnesses1755095__mulishnesses
oafishness1644465_oa_fishne_s_s
peevishnesses2143475_peevishnesses
pettishnesses1844385_pettishnesses
piggishnesses2043285_piggishnesses
pinkishnesses2243985_pinkishnesses
priggishnesses2152375priggishnesses
prudishnesses1943675_prudishnesses
puckishnesses2443335_puckishnesses
raffishness2043375_raffishne_s_s
rashnesses1338725___r_ashnesses
reddishnesses1873585_reddishnesses
richnesses1537805___r_ichnesses
roguishnesses1763975_roguishnesses
ruttishnesses1644045_ruttishnesses
scarinesses1339905scar_i__nesses
sheepishnesses2153015sheepishnesses
shrewishnesses2262245shrewishnesses
sickishnesses2143665_sickishnesses
skittishnesses2052395skittishnesses
sluggishnesses1852145sluggishnesses
sluttishnesses1652685sluttishnesses
smarminesses1645105smarmi__nesses
snobbishnesses2051775snobbishnesses
sottishnesses1544455_sottishnesses
sparsenesses1345805spar__senesses
stylishnesses1843405_stylishnesses
swainishness1852295swainishne_s_s
swampinesses1943715swampi__nesses
swankinesses1944785swanki__nesses
swarthinesses1943455swar_thinesses
swartnesses1436715swar___tnesses
tardinesses121110245_tardi__nesses
tarrinesses11129085_tarri__nesses
tartinesses111011505_tarti__nesses
tearfulnesses1645535tearf_ulnesses
tearinesses11311695tear_i__nesses
thievishnesses2362195thievishnesses
ticklishnesses2352385ticklishnesses
tigerishnesses1852785tigerishnesses
trickishnesses2352505trickishnesses
unselfishnesses2061515unselfishnesses
unwarinesses1546155unwar_i__nesses
uppishnesses1943605__uppishnesses
vaporishnesses2252235vaporishnesses
voguishnesses2063495_voguishnesses
wackinesses2036655_wacki__nesses
waggishness1943025_waggishne_s_s
warmnesses15167355_war___mnesses
washinesses1737265_wa___shinesses
waspinesses1636705_waspi__nesses
waspishness1943085_waspishne_s_s
wavinesses16199285_wa_vi__nesses
waxinesses20138765_wa_xi__nesses
wearifulnesses2054655wearifulnesses
wearinesses14310215wear_i__nesses
wirinesses131811525_wir_i__nesses
wisenesses13310825_w___isenesses
wolfishness2043735_wolfishne_s_s
womanishnesses2252825womanishnesses
wordinesses15138885_wordi__nesses
worminesses16127995_wormi__nesses

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.360496363.9
2DLD Change Limit950241826.76614044.3
3Display Results1821820.1231479.7
 (SQL Overall)1786911827.24924650.4
 
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.