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

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

72 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
memorialist155656(None) 
memorialise1555651memorialise
memorialists1654661memorialists
memorialised1753942memorialised
memorialises1655542memorialises
memorialize2456382memorialize
memorials1346552memorial_s_
aerialist9914263ae__rialist
immoralist1446513immor_alist
manorialism1574983manorialism
materialist1349513materialist
memoirist1345983memo_i_rist
memorial1249523memorial___
memorialising1853063memorialising
memorialized2655303memorialized
memorializes2556003memorializes
memorially1745653memorial_ly
moralist10316663__mor_alist
neorealist1076813ne_orealist
serialist9715113se__rialist
aerialists1089524ae__rialists
amoralism1347954_amor_alism
armorials1145654armorial_s_
cembalist1547634cem__balist
centralist12511064centr_alist
ceremonialist1793644ceremonialist
colonialist1376724colonialist
demoralize2269224demor_alize
editorialist1364654editorialist
emotionalist14146874_emotionalist
federalist1446444feder_alist
formalist141910644__formalist
generalist11169424gener_alist
herbalist1449814he__rbalist
immoralism1355174immor_alism
immoralists1554764immor_alists
immortalise15114464immortalise
imperialist15107774imperialist
madrigalist1583134m_adrigalist
manorialisms1664484manorialisms
materialise1347834materialise
materialism1548264materialism
materialists1456984materialists
medalist11414214me___dalist
medievalist1752894medievalist
memoirists1444134memo_i_rists
memorializing2764814memorializing
memories121214354memori__es_
memorise121411434memor___ise
memorises131211584memori_ses_
memorising1546734memori_sing
memorization2549924memorization
memorizers23125004memorizers_
memorizes221310824memori_zes_
memorizing2448114memori_zing
mentalist11515554me__ntalist
metalist10519354me___talist
moralise10314914__mor_alise
moralism12312364__mor_alism
moralists11311104__mor_alists
muralist10312984__mur_alist
neorealism1265084ne_orealism
neorealists1165284ne_orealists
neutralist10118494neutr_alist
oralist7619634___or_alist
pictorialist1675374pictorialist
semifinalist1772944semifinalist
serialise9912144se__rialise
serialism11811984se__rialism
serialists10810364se__rialists
socialist11411394__socialist
verbalist1449504ve__rbalist

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 Filter1786911488190.420425454.8
2DLD Change Limit148819728.62617252.4
3Display Results72720.0302400.0
 (SQL Overall)178691729.07619688.3
 
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.