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

206 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
visionarinesses1861661visionarinesses_
visionariness1661813visionarine_s_s_
customarinesses1961305customarinesses_
ordinarinesses1552355ordi_narinesses_
visionaries1454255visionari____es_
arbitrarinesses1761426arbitrarinesses_
debonairnesses1771446_debonairnesses_
hoarinesses14310226___ho_arinesses_
idiomaticnesses2071056_idiomaticnesses_
imaginarinesses1861676imaginarinesses_
literarinesses1483356li_terarinesses_
mercenarinesses1961776mercenarinesses_
millionairesses177866milliona_iresses_
rationalnesses1452636rationa_lnesses_
scarinesses1339906__s__carinesses_
secondarinesses1861566_secondarinesses_
silverinesses1643696__silverinesses_
snakinesses1538556__s__nakinesses_
soapinesses1339716__s_o_apinesses_
solitarinesses1452976soli_tarinesses_
sorrinesses11310096__s_o_rrinesses_
sponginesses1544776__spon_ginesses_
stoninesses1138256__ston__inesses_
temporarinesses1961986temporarinesses_
viciousnesses1848056vicio__usnesses_
villainesses1543516v__illa_inesses_
viscousnesses1786006visco__usnesses_
visiblenesses1855326visi__blenesses_
voluntarinesses1862156voluntarinesses_
wintrinesses1555776__wi_ntrinesses_
adversarinesses1971507adversarinesses_
airinesses102613617__ai___rinesses_
airworthinesses2181417airworthinesses_
angrinesses1247287____angrinesses_
biliousnesses1547297bilio__usnesses_
blearinesses1446547___blearinesses_
boninesses121111457___bon__inesses_
bonninesses1337357___bon_ninesses_
braininesses1446557brai_n__inesses_
brininesses1338987_bri_n__inesses_
charinesses1639567____charinesses_
circularnesses1861417circular_nesses_
contrarinesses1674247_contrarinesses_
cursorinesses1553297curso__rinesses_
customariness1761577customarine_s_s_
daintinesses1346247_dai_n_tinesses_
desolatenesses1553977des_olatenesses_
desultorinesses1661287desultorinesses_
dilatorinesses1552057di_latorinesses_
dinginesses1337477__di_n_ginesses_
dismalnesses1553987dis__ma_lnesses_
disparatenesses18122887disparatenesses_
dissolutenesses1561997dissolutenesses_
distantnesses1453837dis__tantnesses_
distinctnesses1752567distin_ctnesses_
drearinesses1347447___drearinesses_
exemplarinesses2661187exemplarinesses_
familiarnesses1971787familiar_nesses_
fierinesses1439237__fi__erinesses_
finicalnesses1853837fini_ca_lnesses_
finickinesses2272067fini__ckinesses_
fishinesses17107247fis____hinesses_
flintinesses1546327_fli_n_tinesses_
flowerinesses1942907__flowerinesses_
foaminesses1658077___fo_aminesses_
friendlinesses1852217_friendlinesses_
frowardnesses20112897__frowardnesses_
glarinesses1239517____glarinesses_
gorinesses11311557___go__rinesses_
graininesses1346597grai_n__inesses_
hairinesses14198947_hai___rinesses_
hungrinesses1643857___hungrinesses_
ignorantnesses1562217_ignorantnesses_
illusorinesses1461657_illusorinesses_
inanenesses1149527___i_nanenesses_
inaptnesses1385637___i_naptnesses_
inertnesses1198727___i_nertnesses_
initialnesses1395617_initia_lnesses_
inkinesses1439427___i_n_kinesses_
innatenesses1247187___innatenesses_
innernesses1146737___inner_nesses_
inviolatenesses1892807inviolatenesses_
inwardnesses1654677___inwardnesses_
ironnesses1047837_i_ron___nesses_
jitterinesses2083317__jitterinesses_
kindlinesses1744247__ki_ndlinesses_
kinglinesses1743857__ki_nglinesses_
kinkinesses1435877__ki_n_kinesses_
lissomenesses1453477lisso__menesses_
livingnesses1643667livi_n__gnesses_
loaminesses1358457___lo_aminesses_
lonelinesses12146347___lonelinesses_
looninesses1197997__loon__inesses_
militantnesses1661877mili_tantnesses_
mirinesses121512317__mi___rinesses_
miserlinesses1554667mis__erlinesses_
missionaries1453627missionari____es_
mistinesses131310627mis____tinesses_
momentarinesses1972347momentarinesses_
mooninesses13127947__moon__inesses_
obstinatenesses1792627obstinatenesses_
ordinariness1362827ordi_narine_s_s_
ornerinesses1246577___ornerinesses_
pastoralnesses1653137pastora_lnesses_
phoninesses1636457__phon__inesses_
raininesses11310487_rai_n__inesses_
resignednesses1652137resign_ednesses_
riskinesses1537837ris____kinesses_
saintlinesses1344367__saintlinesses_
salutarinesses1462777_salutarinesses_
sandinesses12911397__s_an_dinesses_
savorinesses1544617__s_avorinesses_
scalinesses1339327__s__calinesses_
scantinesses1437317__scan_tinesses_
seaminesses13310757__s__eaminesses_
semidarknesses2161297semi_darknesses_
shadinesses1538647__s__hadinesses_
shakinesses1837617__s__hakinesses_
sharpnesses1645237__s__harpnesses_
shininesses1448297__shin__inesses_
shoddinesses1743787__sho_ddinesses_
shortnesses1446797__sho__rtnesses_
showinesses1735997__sho__winesses_
sicklinesses1844867__si_cklinesses_
sightlinesses1743867__sightlinesses_
silkinesses1557907__si__lkinesses_
sillinesses1169847__si__llinesses_
sincerenesses1554737__sincerenesses_
sinfulnesses1546137__si_nfulnesses_
singlenesses1346107__si_nglenesses_
sinisternesses1352117sinister_nesses_
sissinesses9118317__si__ssinesses_
sizinesses1938657__si___zinesses_
skinninesses1643477__skin_ninesses_
slanginesses1346967__slan_ginesses_
slatinesses11311637__s__latinesses_
sleazinesses2145377__s_leazinesses_
slinkinesses1645817__slin_kinesses_
slipperinesses1851857_slipperinesses_
sloppinesses1644057__slo_ppinesses_
slouchinesses1842807__slouchinesses_
smarminesses1645107__s__marminesses_
smartnesses1337147__s__martnesses_
smokinesses1736257__smo__kinesses_
snappinesses1684327__s__nappinesses_
sneakinesses1645907__s_neakinesses_
snootinesses1265807__sno_otinesses_
snottinesses1255847__sno_ttinesses_
snowinesses1436417__s__nowinesses_
sobernesses1346597__s_ober_nesses_
sogginesses1346777__s_o_gginesses_
sootinesses11410057__s_o_otinesses_
soppinesses1566847__s_o_ppinesses_
sorenesses101313497__s_o__renesses_
sournesses10310017__s_o_ur_nesses_
spacinesses1538107__s__pacinesses_
sparenesses1339177__s__parenesses_
spininesses1358457__spin__inesses_
spookinesses1844097__spo_okinesses_
sportinesses1447877__spo_rtinesses_
spottinesses1445687__spo_ttinesses_
springinesses16104067spri_n_ginesses_
spunkinesses1844387__spun_kinesses_
squarenesses2144977__s_quarenesses_
staginesses1238467__s__taginesses_
starknesses1545887__s__tarknesses_
steadinesses1346907__s_teadinesses_
steaminesses1446227__s_teaminesses_
stinginesses1375967__stin_ginesses_
stockinesses1844507__sto_ckinesses_
stodginesses1443947__sto_dginesses_
storminesses1445037__sto_rminesses_
streakinesses1743637__streakinesses_
stringinesses14124537stri_n_ginesses_
sultrinesses1245887__s_ultrinesses_
sunninesses11148387__s_un_ninesses_
swankinesses1944787__swan_kinesses_
swartnesses1436717__s__wartnesses_
sweatinesses1546917__s_weatinesses_
tearinesses11311697____tearinesses_
throatinesses1653277_thro_atinesses_
tininesses10311167__ti_n__inesses_
tinninesses1136867__ti_n_ninesses_
unkindlinesses1952567unki_ndlinesses_
unsightlinesses1962217unsightlinesses_
unsteadinesses1553067uns_teadinesses_
untowardnesses1862337_untowardnesses_
unwarinesses1546157___unwarinesses_
vainnesses1337347v_ai_n___nesses_
valiantnesses1652727vali__antnesses_
variousnesses1648677vario__usnesses_
venialnesses1555707veni__a_lnesses_
vigorousnesses1865527vi_gorousnesses_
violablenesses1984737v__iolablenesses_
viscountesses1851807visco__untesses_
visionless1342967vision___le_s_s_
vitalnesses1456277v__i_ta_lnesses_
vividnesses1844227vivi____dnesses_
vocalnesses1645097v___oca_lnesses_
votaresses1343917v___otar__esses_
warinesses131514527_____warinesses_
wearinesses14310217____wearinesses_
whininesses1746187_whi_n__inesses_
windinesses1557817__wi_n_dinesses_
wirinesses131811527__wi___rinesses_
wispinesses1636277wis____pinesses_

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 Filter178691950240.1231452772.4
2DLD Change Limit950242069.6439854.2
3Display Results2062060.1531346.4
 (SQL Overall)1786912069.91918015.0
 
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.