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

106 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
vocalisms1613805(None) 
localisms13148731localisms
vocalises141710321vocalises
vocalism15159041vocalism_
vocalists14108891vocalists
focalises14139952focalises
localises111411462localises
localism121310012localism_
localists11149792localists
loyalisms14156622loyalisms
moralisms13410292moralisms
oralisms10610972_oralisms
royalisms14127262royalisms
socialisms1447642socialisms
totalisms1139812totalisms
vitalisms1448512vitalisms
vocaleses14145312vocaleses
vocalics1545592vocali_cs
vocalise131510812vocalis_e
vocalised15157392vocalised
vocalist131512122vocalis_t
vocalizes231610102vocalizes
volcanisms1744582volcanisms
amoralisms1447043amoralisms
atonalisms1247953atonalisms
baalisms1238033_baalisms
botulisms1345303botulisms
boyarisms1645443boyarisms
cabalisms1548433cabalisms
cocainisms1645143cocainisms
dualisms1147213_dualisms
escapisms1543943escapisms
fatalisms1439113fatalisms
finalisms14318833finalisms
focalise131210373focalis_e
focalised15156953focalised
focalizes23159323focalizes
formalisms17227243formalisms
globalisms1544383globalisms
holisms123811113ho__lisms
idealisms1246443idealisms
iotacisms1346103iotacisms
kabalisms1745953kabalisms
legalisms1247163legalisms
localise101511853localis_e
localised12167863localised
localist101613963localis_t
localites111210433localites
localizes201510543localizes
locoisms1256143loc_oisms
loyalism13167573loyalism_
loyalists12137473loyalists
monadisms1446253monadisms
moralises11314003moralises
moralism12312363moralism_
moralists11311103moralists
nasalisms1147173nasalisms
nomadisms1445163nomadisms
obelisms1236393_obelisms
oculists1037133_oculists
odalisks1363503_odalisks
onanisms1048063_onanisms
oralism9513763_oralism_
oralists8611803_oralists
oxalises1538503_oxalises
populisms1545193populisms
ptyalisms1685303ptyalisms
racialisms1447223racialisms
realisms102212163_realisms
royalism13128473royalism_
royalists12178113royalists
ruralisms1147353ruralisms
socialises1258253socialises
socialism1348663socialism_
socialists1248493socialists
sodalists1038153sodalists
solarisms1168813solarisms
totalises9311773totalises
totalism10311093totalism_
totalists9310753totalists
valises103516263v__alises
vandalisms1645803vandalisms
veganisms1545413veganisms
verbalisms1746113verbalisms
virilisms1446243virilisms
vitalises12310093vitalises
vitalism1339683vitalism_
vitalists1239223vitalists
vocalese13165493vocales_e
vocalic1446943vocali__c
vocalising1645523vocalising
vocalities1549393vocalities
vocality16137933vocali_ty
vocalize221310153vocali_ze
vocalized24178813vocalized
vocalizer23187573vocalizer
vocalizers24185103vocalizers
vocalness1444383vocalness
vocals113811583vocal___s
vocations141911423vocations
vocatives1745883vocatives
volcanism1645233volcanism_
voltaisms1444143voltaisms
votarists1298603votarists
vulcanisms1753623vulcanisms
womanisms1646893womanisms

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 Filter1786911486410.190940478.9
2DLD Change Limit1486411067.64019455.6
3Display Results1061060.0462304.3
 (SQL Overall)1786911067.87622688.0
 
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.