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

139 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
moralists1131109(None) 
moralises11314001moralises
moralisms13410291moralisms
moralist10316661moralist_
muralists1148151muralists
oralists8611791_oralists
amoralisms1447032amoralisms
formalists15217612formalists
immoralists1554752immoralists
localists11149792localists
loyalists12137472loyalists
medalists1249362medalists
metalists11412652metalists
modelists1246472modelists
moralise10314912moralis_e
moralised1239662moralised
moralism12312362moralis_m
moralistic1446792moralistic
morality131110332morali_ty
moralizes20312852moralizes
muralist10312982muralist_
oralisms10610972_oralisms
oralist7619632_oralist_
royalists12178102royalists
ruralists947632ruralists
sodalists1038152sodalists
totalists9310742totalists
vocalists14108892vocalists
aerialists1089513aerialists
amoralism1347943amoralis_m
amorality1446713amorali_ty
amorists10411323amor__ists
annalists949063annalists
aorists74215823aor__ists
arbalists1148473arbalists
atonalists1048463atonalists
botanists1148193botanists
cabalists1339143cabalists
ceramists1346713ceramists
dialists9411413_dialists
dualists958243_dualists
fatalists12310013fatalists
finalists123010163finalists
focalises14139953focalises
forklifts1941973forklifts
formalises15258993formalises
formalisms17227243formalisms
formalist141910643formalist_
formulists15204703formulists
globalists1344693globalists
heraldists1443943heraldists
herbalists1546183herbalists
holists104413963ho__lists
homilists1456803homilists
hornists11208833hor_nists
idealists1047223idealists
immoralisms1454633immoralisms
immoralist1446513immoralist_
journalists1853633journalists
kabalists1546293kabalists
legalists1047943legalists
localises111411463localises
localisms13148733localisms
localist101613963localist_
loyalisms14156623loyalisms
loyalist111511133loyalist_
maists85817573m__a_ists
medalist11414203medalist_
medallists1344363medallists
melanists1148613melanists
memorialists1654663memorialists
mentalists12410473mentalists
metalises11315063metalises
metalist10519353metalist_
metallists1266713metallists
midlists1137523m_idlists
mobilises1347513mobilises
modality14117643modali_ty
modelist11310503modelist_
molality13118363molali_ty
molests93311563mo__lests
monadisms1446253monadisms
monists93614783mo__nists
monodists1247703monodists
moraines10314343mora_ines
morales93619403moral__es
moralising1347623moralising
moralities121111923moralities
moralize19313923morali_ze
moralized21310753moralized
moralizer2049473moralizer
moralizers2145843moralizers
morals85324633moral___s
morass84614493mora__s_s
morasses1038903mora_sses
moronisms1348173moronisms
morrises10711063mor_rises
mortality1467733mortali_ty
mortises10713603mor_tises
mosaicists1443993mosaicists
motorists1149893motorists
mutualists1244843mutualists
neorealists1165273neorealists
normalises12228493normalises
novelists1245933novelists
oculists1037133_oculists
odalisks1363503_odalisks
onanists838413_onanists
ooralis7312553oorali__s
oralism9513763_oralis_m
orality101111683_orali_ty
organists1047383_organists
oxalises1538503_oxalises
pluralists1245363pluralists
pollists10910823po_llists
populists1345493populists
racists92613323__racists
rapists92510743__rapists
realists83014833_realists
relists73817053__relists
royalisms14127263royalisms
royalist111311983royalist_
ruralises939123ruralises
ruralisms1147353ruralisms
ruralist8311703ruralist_
serialists10810353serialists
shortlists1344083shortlists
socialists1248493socialists
sodalist9311883sodalist_
totalises9311773totalises
totalisms1139803totalisms
totalist8315583totalist_
verbalists1546153verbalists
vitalists1239223vitalists
vocalises141710323vocalises
vocalisms16138053vocalisms
vocalist131512123vocalist_
votarists1298593votarists
womanists1446753womanists

Search took 9 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.1561145455.1
2DLD Change Limit1486411398.40617682.7
3Display Results1391390.0632206.3
 (SQL Overall)1786911398.62520717.8
 
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.