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

115 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
violists113766(None) 
violist10312141violist_
biblists1236872biblists
dialists9411412dialists
holists104413962_holists
midlists1137522midlists
sciolists1147212sciolists
titlists837292titlists
vibists1256482vi_bists
violets102210002viol_ets
violinists1344442violinists
violins10311452violi_ns
vitalists1239222vitalists
volosts1036562v_olosts
agonists9289833agonists
aiolis6316843aioli__s
airlifts1143633airlifts
amorists10411333amorists
aorists74215833_aorists
atomists102610963atomists
aviarists1246613aviarists
biblist11310833biblist_
biologists1349433biologists
biolyses1345573biolyses
biolysis1345363biolysis
cellists1038563cellists
cyclists1545713cyclists
delists84414173_delists
diabolists1354463diabolists
dialist8517763dialist_
diallists1056003diallists
diarists9410363diarists
dualists958243dualists
duelists966003duelists
egoists887073ego_ists
egotists937063egotists
enlists749393_enlists
fideists1245543fideists
finalists123010163finalists
florists1138813florists
foists95413983_fo_ists
gnomists1145473gnomists
hoists95516023_ho_ists
holisms123811113_holisms
holist94723213_holist_
idolises938763idolises
idolisms1146353idolisms
idylists1244123idylists
insists739083_insists
iodises83413633_iodises
iodisms10308483_iodisms
iolite63221983_ioli_te
iolites73819483_iolites
ionises72916433_ionises
ironists839293ironists
joists134711033_jo_ists
libelists1146953libelists
lionises8310313lionises
lists56628693___lists
lookists1245713lookists
midlist10312513midlist_
molests93311563_molests
monists93614783_monists
niellists944793niellists
nihilists1244853nihilists
oboists937903obo_ists
oculists1037133oculists
odists749853__odists
ologists939443ologists
oralists8611803oralists
pianists1049013pianists
pietists1038323pietists
piolets93513193piol_ets
pollists10910823pollists
poloists10910523_poloists
protists10313363protists
realists83014843realists
relists73817053_relists
rigorists1045673rigorists
sciolisms1346223sciolisms
sciolist10410233sciolist_
shitlists1245533shitlists
simonists1146763simonists
simplists13266503simplists
soloists869153_soloists
stylists11207023stylists
titlist7312923titlist_
unionists946213unionists
utopists1045773utopists
valises103516263v_alises
verists103613673v_erists
vibist11610583vi_bist_
vilest9416843vi_lest_
violas93713523viol__as
violate10311553viol_ate
violates11311193violates
violent102110813violent_
violet92620923viol_et_
violin9311983violi__n
violinist1247373violinist
violones1137383violones
viols86118103viol___s
virilisms1446243virilisms
virologists1546633virologists
visits9311423vi_si_ts
visualists1344893visualists
vitalises12310093vitalises
vitalisms1448513vitalisms
vitalist11313393vitalist_
vocalists14108893vocalists
volost9412643v_olost_
volts85421293v_ol__ts
vomits112610923v_omi_ts
waitlists1244603waitlists
wholisms1665253wholisms

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621156.72021750.3
3Display Results1151150.0462500.0
 (SQL Overall)1786911157.18624866.5
 
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.