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

119 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
vocalist13151212(None) 
localist101613961localist
vocalise131510811vocalise
vocalism15159041vocalism
vocalists14108891vocalists
focalise131210372focalise
localise101511852localise
localism121310012localism
localists11149792localists
loyalist111511132loyalist
moralist10316662moralist
oculist9310882_oculist
oralist7619632_oralist
royalist111311982royalist
socialist11411392socialist
sodalist9311882sodalist
totalist8315582totalist
vitalist11313392vitalist
vocalese13165492vocalese
vocalic1446942vocali_c
vocalics1545592vocalics
vocalised15157392vocalised
vocalises141710322vocalises
vocalisms16138052vocalisms
vocality16137932vocality
vocalize221310152vocalize
vocals113811582vocal_s_
votarist111012162votarist
alist56136783___alist
annalist8413753annalist
arbalist10313333arbalist
atonalist9411823atonalist
backlist16910653backlist
botanist10412033botanist
cabalist12314493cabalist
coaliest10316223co_aliest
cyclist1438853cyc_list
dialist8517763_dialist
dualist8614053_dualist
escapist1246213escapist
fatalist11314973fatalist
finalist113014733finalist
fiscalist1446573fiscalist
focalised15156953focalised
focalises14139953focalises
focalize22139503focalize
formalist141910643formalist
globalist1256763globalist
holist94723213ho__list
homilist13410033homilist
idealist9310653idealist
kabalist14410083kabalist
legalist9512393legalist
locales93715093locales_
localised12167863localised
localises111411463localises
localisms13148733localisms
localite101411543localite
locality13148433locality
localize191410483localize
locals83714503local_s_
loyalest11146723loyalest
loyalism13167573loyalism
loyalists12137473loyalists
medalist11414203medalist
metalist10519353metalist
modelist11310503modelist
moralise10314913moralise
moralism12312363moralism
moralists11311093moralists
muralist10312983muralist
novelist1149453novelist
oculists1037133_oculists
odalisk1265373_odalisk
onanist7314633_onanist
ooralis7312553ooralis_
oralism9513763_oralism
oralists8611793_oralists
oxalis1339223_oxalis_
pollist9816603po_llist
populist1248203populist
racialist11411193racialist
realist73225383_realist
royalism13128473royalism
royalists12178103royalists
ruralist8311703ruralist
scaliest101714383_scaliest
socialise1148733socialise
socialism1348663socialism
socialists1248493socialists
sodalists1038153sodalists
totalise8312503totalise
totalism10311093totalism
totalists9310743totalists
valise92917643v__alise
vealiest112513203v_ealiest
verbalist1449503verbalist
violist10312143v_iolist
visualist1246773visualist
vitalise11310743vitalise
vitalism1339683vitalism
vitalists1239223vitalists
vocables15145733vocables_
vocabs13336313voca_bs_
vocal104715643vocal___
vocaleses14145313vocaleses
vocalising1645523vocalising
vocalized24178813vocalized
vocalizer23187573vocalizer
vocalizes231610103vocalizes
vocally15188343vocal_ly
vocalness1444383vocalness
vocation132311983vocation
vocative1637913vocative
volcanism1645233volcanism
volost9412643vo__lost
votarists1298593votarists
womanist13410433womanist
zocalos1835393zocalos_

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 Filter1786911461620.326548131.9
2DLD Change Limit1461621199.26615774.0
3Display Results1191190.0462587.0
 (SQL Overall)1786911199.63818540.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.