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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

94 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
royalists1217811(None) 
loyalists12137471loyalists
royalisms14127261royalisms
royalist111311981royalist_
localists11149792localists
loyalisms14156622loyalisms
loyalist111511132loyalist_
moralists11311102moralists
oralists8611802_oralists
realists83014842r_ealists
royalism13128472royalis_m
royalmasts155982royalmasts
ruralists947642ruralists
sodalists1038152sodalists
totalists9310752totalists
vocalists14108892vocalists
annalists949063annalists
arbalists1148483arbalists
atonalists1048493atonalists
botanists1148203botanists
boyarisms1645443boyarisms
cabalists1339153cabalists
cyclists1545713_cyclists
dialists9411413_dialists
dualists958243_dualists
fatalists12310023fatalists
finalists123010163finalists
focalises14139953focalises
formalists15217623formalists
frontlists1344523frontlists
globalists1344693globalists
holists104413963ho__lists
homilists1456813homilists
idealists1047223idealists
idylists1244123idy_lists
idyllists1342443idyllists
kabalists1546293kabalists
legalists1047943legalists
localises111411463localises
localisms13148733localisms
localist101613963localist_
loyalest11146723loyalest_
loyalism13167573loyalis_m
medalists1249373medalists
metalists11412663metalists
modelists1246473modelists
moralises11314003moralises
moralisms13410293moralisms
moralist10316663moralist_
muralists1148163muralists
novelists1245933novelists
oculists1037133_oculists
odalisks1363503_odalisks
onanists838413_onanists
oralisms10610973_oralisms
oralist7619633_oralist_
organists1047383organists
oxalises1538503_oxalises
playlists1444783playlists
pollists10910823po_llists
populists1345493populists
prosaists1157503prosa_ists
ptyalisms1685303ptyalisms
racialists1247703racialists
racists92613323r__acists
rapists92510753r__apists
realises82420183r_ealises
realisms102212163r_ealisms
realist73225383r_ealist_
reenlists946263reenlists
relists73817053r__elists
ritualists1046173ritualists
roasts64915413ro_a__sts
romanises11311573romanises
royalmast1451413royalmast_
royals93711263royal___s
royalties1244913royalties
royalty13165113royal__ty
ruralises939123ruralises
ruralisms1147353ruralisms
ruralist8311703ruralist_
socialists1248493socialists
sodalist9311883sodalist_
stylists11207023sty_lists
totalises9311783totalises
totalisms1139813totalisms
totalist8315583totalist_
tribalists1286943tribalists
vitalists1239223vitalists
vocalises141710333vocalises
vocalisms16138053vocalisms
vocalist131512123vocalist_
votarists1298603votarists
womanists1446763womanists

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.406440125.6
2DLD Change Limit148641947.51619776.6
3Display Results94940.0462043.5
 (SQL Overall)178691947.96822426.1
 
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.