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

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

246 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
dualist861405(None) 
dialist8517761dialist
dualism1049161dualism
dualists958241dualists
duelist8511411duelist
alist56136782__alist
delist74625052d_elist
dialists9411412dialists
diallist949552diallist
diarist8517112diarist
dualisms1147212dualisms
dualistic1246102dualistic
duality1147962duality
dualize1759762dualize
duals65620082dual_s_
duelists966002duelists
duellist986332duellist
dullest8312632dullest
dullish1148742dullish
idealist9310652idealist
muralist10312982muralist
oralist7619632oralist
realist73225382realist
ruralist8311702ruralist
agist66325583__agist
alit46155693__ali_t
analyst10189323analyst
annalist8413753annalist
aquarist171010083aquarist
arbalist10313333arbalist
atavist10311093atavist
aurist65027253au_rist
autist64324943au_tist
baalism11310593baalism
bialis83617163bialis_
biblist11310833biblist
bubalis11359903bubalis_
bulliest104314503bulliest
bullish12511193bullish
bundist10310193bundist
burliest103113063burliest
cabalist12314503cabalist
caulis85320083caulis_
cellist9314423cellist
cladist10311973cladist
coaliest10316223coaliest
cubist104214443cu_bist
cullis84115993cullis_
cultist91412713cultist
curliest102713123curliest
cyclist1438853cyclist
czarist18710223czarist
dadaist9310103dadaist
dais57040703d_a_is_
daisy95915313d_a_isy
dalasi7610623d_alasi
dales66439743d_ales_
dals57145123d_al_s_
danish101513793d_anish
daubiest1138233daubiest
davit93424593d_avi_t
davits104012363d_avits
daylit10512493dayli_t
deadest93014883deadest
deadliest1138183deadliest
deadlift1345633deadlift
deafest112911513deafest
deafish1438533deafish
dealfish1545503dealfish
dealing94323233dealing
deals65435343deal_s_
dealt65234283deal__t
dearest83618673dearest
deist64633593d__eist
delict94320333d_elict
delis64928543d_elis_
delish105215613d_elish
delists84414173d_elists
dentist8316743dentist
desist74818813d_esist
dhals95415443dhal_s_
diabolist1256493diabolist
dialect101210263dialect
dialing94318173dialing
diallists1056003diallists
dialogist1148273dialogist
dials64925343dial_s_
dialyse1135463dialyse
diarists9410363diarists
digamist1248213digamist
dollish11610093dollish
drails74716953drails_
drawliest13166243drawliest
druggist11163663druggist
drumliest1235433drumliest
duads76515343dua_ds_
dual55928173dual___
dualized1937403dualized
dualizes1838823dualizes
dually103210063dual_ly
duckiest153211863duckiest
dudish1148313du_dish
dueling93614543dueling
duellists1053753duellists
duels65619233duel_s_
duettist945513duettist
duit56241583du__i_t
duits65021883du__its
dulcet9314493du_lcet
dulia61014983du_li_a
dulias71212743du_lias
dulling93418273dulling
dulls64523743du_lls_
dulse65415043du_l_se
dumbest1238743dumbest
dumpiest1338743dumpiest
dumpish15116113dumpish
duncish1335793duncish
dungiest102810743dungiest
dunlin739723dunli_n
dunlins849553dunlins
dunnest83312263dunnest
durmast1037623durmast
durst66125173du__rst
duskiest133710083duskiest
duskish1535183duskish
dust57142533du___st
dustiest93015073dustiest
dynamist1445343dynamist
enlist6417043_enlist
equalise1748213equalise
etatist7415033etatist
fatalist11314973fatalist
fauvist1336663fauvist
feudalist1356303feudalist
finalist113014733finalist
fuguist1136073fuguist
fullest10313343fullest
galiot72322593_galiot
gradualist1254253gradualist
halest94823273_halest
holist94723213_holist
humanist13410493humanist
idealise938053idealise
idealism1147013idealism
idealists1047223idealists
idylist1146653idylist
idyllist1243963idyllist
imagist1077333imagist
judoist1545633judoist
jujuist1343073jujuist
jurist134616393ju_rist
kabalist14410083kabalist
legalist9512393legalist
list47055343___list
localist101613963localist
loyalist111511133loyalist
lutanist8410273lutanist
lutist64317553lu_tist
maist75535683_ma_ist
mealiest102215973mealiest
medalist11414213medalist
metalist10519353metalist
midlist10312513midlist
moralist10316663moralist
mulish11311903mu_lish
muralists1148163muralists
mutualist1146403mutualist
nudist73813323nu_dist
oculist9310883oculist
odalisk1265373odalisk
onanist7314633onanist
oralism9513763oralism
oralists8611803oralists
outlast71015443outlast
oxalis1339223oxalis_
palest83926223_palest
paliest93021603_paliest
palish114718273_palish
palmist112814343_palmist
papist102618743_papist
phallist1338983phallist
pianist9615103pianist
playlist1347573playlist
pluralist1148173pluralist
pollist9816603pollist
psalmist1276353psalmist
publish1447913publish
pugilist11136633pugilist
pulis74225603pu_lis_
purist85525053pu_rist
quails153412643quails_
quaint15415173qua_int
quais144618393qua_is_
quakiest2138583quakiest
qualia1559563quali_a
qualify2235473qualify
quality1938563quality
qualmiest2044393qualmiest
qualmish2244013qualmish
qualms17317243qualms_
querist16311133querist
racist82822793_racist
rapist82520673_rapist
realest73322433realest
realise73021813realise
realism93115923realism
realists83014843realists
relist64628413_relist
ritualist948643ritualist
royalist111311983royalist
ruliest72816433ru_liest
ruralise839643ruralise
ruralism1048533ruralism
ruralists947643ruralists
sadist74221353_sadist
scaliest101714393scaliest
sealift10312793sealift
shaliest111415053shaliest
sodalist9311883sodalist
stalest73720173stalest
statist7317723statist
stylist102110283stylist
suavest10310623suavest
subsist9311573subsist
sumoist9311613sumoist
sunlit61516103sunli_t
surliest82416913surliest
tanist6324593_tanist
titlist7312923titlist
totalist8315583totalist
tsarist7712253tsarist
tubaist938703tubaist
tubist83013163tu_bist
tzarist1659103tzarist
ugliest8410153_ugliest
unlit55025463_unli_t
uplift114610653_uplift
uplit76020803_upli_t
valise92917643_valise
vealiest112513203vealiest
violist10312143violist
visualist1246773visualist
vitalist11313393vitalist
vocalist131512123vocalist
waist86132383_wa_ist

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 Filter1786911340270.296603685.8
2DLD Change Limit1340272467.06318975.9
3Display Results2462460.0932645.2
 (SQL Overall)1786912467.45223978.9
 
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.