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

166 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
adventurist155364(None) 
adventurism1752711adventurism
adventurists1652531adventurists
adventures1444762adventures_
adventuress1552892adventuress
adventuring1652972adventuring
adventurisms1862452adventurisms
adventuristic1961502adventuristic
denturist1048462_d_enturist
adventure1344393adventur__e
adventured1543343adventur_ed
adventurer1442973adventur_er
adventurers1552433adventurers
adventurous1552453adventurous
aventurin1244033a_venturi_n
aventurine1344123a_venturine
aventurins1344213a_venturins
denturists1145353_d_enturists
venturis1138193__venturis_
adventitia1452604adventiti_a
adventitial1552114adventitial
adventitias1552274adventitias
adventive1645814advent__ive
adventives1745124adventives_
advents11309474advent___s_
adventuresome1971164adventuresome
adventuresses1761694adventuresses
adventurously2061724adventurously
advertise1346104advert__ise
advertorial1552624advertorial
auteurist946784aute__urist
aventurines1453754a_venturines
centrist10314864__cent_rist
dentist8316744_d_ent__ist
dentures9312454_d_entures_
ventures11311494__ventures_
venturi1037204__venturi__
venturing1337554__venturing
absenteeism1561115absenteeism
absenters1156175absenter_s_
accentors13116055accentor_s_
acentric1247535a_cent_ri_c
acupuncturist197965acupuncturist
addendums1451955addendu_ms_
adenitis947435ad_en_itis_
adenosis946345ad_en_osis_
adeptest1145455ad_ept__est
admeasures1352435admeasures_
admeasuring1551615admeasuring
admixtures2052195admixtures_
advancers1542995advancer_s_
advantages1552345advantages_
advantaging1751785advantaging
advecting1645115advect__ing
advection1545555advect__ion
advections1645555advections_
advective1845235advect__ive
advects13276015advect___s_
advent102613755adven_____t
adventitious1652235adventitious
adverbs13254275adve___rbs_
adversarial1551695adversarial
adversaries1553235adversaries
adverse1145955adve___r_se
adversity1643815adve___rsity
advert103215785adve___r__t
advertent1356595advert__ent
adverting1437225advert__ing
advertised1544095advert__ised
advertiser1443615advert__iser
advertises1445915advert__ises
advertising16143615advertising
advertize2245385advert__ize
advertizes2344675advertizes_
advertizing25144305advertizing
advertorials1651515advertorials
adverts11308515adve___rts_
agentries1048235a_gent_ries
alienist8411995alien___ist
allegorist1184765alle_gorist
altruist857955a___ltruist
aneurism1046645a___neurism
antiriot8414585a___ntiriot
antirust8411175a___ntirust
apertures1146475a_pertures_
apiculturist16134575apiculturist
argentums1243875argentu_ms_
assenters966995assenter_s_
assentors955655assentor_s_
aurist65027255a_____urist
auteurism1144615aute__urism
auteurists1045095aute__urists
avengers1235585a_venger_s_
aventail1145345a_vent_ai_l
aventails1244995a_vent_ails
avenues1057185a_ven_u_es_
averters11249515a_verter_s_
aviarist11410115a_v__iarist
aviculturist17134695aviculturist
calentures1244615calentures_
caricaturist1663535caricaturist
centrism1249645__cent_rism
centrists11410235__cent_rists
centurial1147955__centurial
centuries11311335__centuries
centurion1165885__centurion
covertures1545465covertures_
culturist1178095__culturist
davenport1552825davenpor__t
davenports1651305davenports_
debentures1343535debentures_
demurest1137455_d_e_murest
denaturant1154515_d_enaturant
denatures1038135_d_enatures_
denaturing12115865_d_enaturing
dentists939265_d_ent__ists
dentural948085_d_entur_al
denture8311895_d_entur__e
detentist1049325detent__ist
divestures14144255divestures_
downburst1572415_downbur_st
downturns1342475_downturns_
duettist945515_due_t_tist
entrust7410885___ent_rust
entwist1048805___ent_wist
futurist1148285___futurist
identikit1453465id_entiki_t
indentures1144865indentures_
indenturing1342875indenturing
inventers12269535inventer_s_
inventorial1453985inventorial
inventoried1552845inventoried
inventories1454705inventories
inventors12288255inventor_s_
inventress1343625invent_ress
liverwurst1651615liverwur_st
mentalist11515555__mentalist
metrist9317065__me_t_rist
miniaturist1353545miniaturist
misadventures1961425misadventures_
monetarist1258335mone_tarist
naturist8410815___naturist
orientalist1197825orientalist
overnourish1753055_overnourish
overtures121611455_overtures_
overturing1499415_overturing
overturns12136625_overturns_
peradventures1961265peradventures_
posturist11410445__posturist
scenarist1147825_scen_arist
scientist1147225scient__ist
tenebrist1145645__tenebrist
tenorist8413025__ten_orist
unadventurous177805unadventurous
venters103717735__venter_s_
venture10311175__ventur__e
ventured1238275__ventur_ed
venturer1137245__ventur_er
venturers1245525__venturers
venturous1245585__venturous
verist93823895__ve___rist
vestures11311045__vestures_
vesturing1337205__vesturing
voluntarist1474415voluntarist
votarist111012165__v_otarist
vulturish1544005__vulturish

Search took 14 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 Filter1786911646070.436409841.7
2DLD Change Limit16460716612.94012720.8
3Display Results1661660.0901844.4
 (SQL Overall)17869116613.46613269.8
 
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.