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

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

51 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
existentialists2217230(None) 
existentialisms24182151existentialisms
existentialist21232691existentialist_
existentialism23182532existentialis_m
essentialists1363063e__ssentialists
essentialisms1563274e__ssentialisms
essentialist1263874e__ssentialist_
existential1853884existential____
existentially2363184existential__ly
editorialists1463415edi_t_orialists
essentialism1463395e__ssentialis_m
essentiality1563505e__ssentiali_ty
essentializes2263485e__ssentializes
millennialists1671755_millennialists
orientalists12125775ori__ent_alists
centralists1348146____centralists
credentialisms1963176_credentialisms
documentalists19153956document_alists
editorialist1364656edi_t_orialist_
epistemologists2072126epistemologists
essentialities1473246e__ssentialities
essentialize2163766e__ssentiali_ze
essentialized2363266e__ssentialized
essentialness1363266e__ssentialness
essentials1054586e__ssential___s
existents1644986existen______ts
exponentials21102236exponential___s
exponentiations2461736exponentiations
externalises1955466ex__te_rnalises
externalisms2154956ex__te_rnalisms
extortionists2074386ex__tortionists
immaterialists1883516immate_rialists
imperialists16105406__impe_rialists
literalists1148076_li_te__ralists
materialists1456986__mate_rialists
mentalists12410486____ment_alists
millennialisms1871966_millennialisms
millennialist1562366_millennialist_
nonspecialists1882746nonspe_cialists
orientalisms14105906ori__ent_alisms
orientalist1197826ori__ent_alist_
penitentiaries1691496peni_tentiari_es
pictorialists1774116_pict_orialists
pointillists1453076poi___ntillists
potentiality1754336__potentiali_ty
sensualists1154476___s_ensualists
sentimentalists17144636sentiment_alists
serialists10810366___s_e_rialists
specialists1546206___spe_cialists
subspecialists2061996subspe_cialists
substantiality1972766substantiali_ty

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 Filter178691950240.343520965.0
2DLD Change Limit95024516.95313666.6
3Display Results51510.0461108.7
 (SQL Overall)178691517.34224338.2
 
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.