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

104 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
royalist11131198(None) 
loyalist111511131loyalist
royalism13128471royalism
royalists12178111royalists
localist101613962localist
loyalest11146722loyalest
loyalism13167572loyalism
loyalists12137472loyalists
moralist10316662moralist
oralist7619632_oralist
realist73225382r_ealist
royalisms14127262royalisms
royalmast1451412royalmast
royals93711262royal_s_
ruralist8311702ruralist
sodalist9311882sodalist
totalist8315582totalist
vocalist131512122vocalist
alist56136783___alist
annalist8413753annalist
arbalist10313333arbalist
atonalist9411833atonalist
botanist10412033botanist
boyarism1546393boyarism
cabalist12314503cabalist
coaliest10316223co_aliest
cyclist1438853_cyclist
dialist8517763_dialist
dualist8614053_dualist
fatalist11314973fatalist
finalist113014733finalist
focalise131210373focalise
formalist141910643formalist
frontlist1246123frontlist
globalist1256763globalist
holist94723213ho__list
homilist13410033homilist
idealist9310653idealist
idylist1146653idy_list
idyllist1243963idyllist
kabalist14410083kabalist
legalist9512393legalist
localise101511853localise
localism121310013localism
localists11149793localists
loyalisms14156623loyalisms
medalist11414213medalist
metalist10519353metalist
modelist11310503modelist
moralise10314913moralise
moralism12312363moralism
moralists11311103moralists
muralist10312983muralist
novelist1149453novelist
oculist9310883_oculist
odalisk1265373_odalisk
onanist7314633_onanist
ooralis7312553ooralis_
oralism9513763_oralism
oralists8611803_oralists
organist9411543organist
oxalis1339223_oxalis_
playlist1347573playlist
pollist9816603po_llist
populist1248203populist
prosaist10611583prosa_ist
ptyalism15115793ptyalism
racialist11411203racialist
racist82822793r__acist
rapist82520673r__apist
realest73322433r_ealest
realise73021813r_ealise
realism93115923r_ealism
realists83014843r_ealists
reenlist8410363reenlist
relist64628413r__elist
ritualist948643ritualist
riyals94111083riyal_s_
roast56230143ro_a__st
robalos937683robalos_
roiliest8312283ro_iliest
romajis1635913romajis_
romanise10312133romanise
royal85014703royal___
royally13157733royal_ly
royalmasts155983royalmasts
royalties1244913royalties
royalty13165113royal_ty
ruralise839643ruralise
ruralism1048533ruralism
ruralists947643ruralists
socialist11411393socialist
sodalists1038153sodalists
stylist102110283sty_list
totalise8312503totalise
totalism10311093totalism
totalists9310753totalists
tribalist1149953tribalist
vitalist11313393vitalist
vocalise131510813vocalise
vocalism15159043vocalism
vocalists14108893vocalists
votarist111012163votarist
womanist13410433womanist

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 Limit1461621047.19020328.5
3Display Results1041040.0303466.7
 (SQL Overall)1786911047.64023388.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.