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

92 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
materialists145698(None) 
materialises1447321materialises
materialisms1657301materialisms
materialist1349511materialist_
aerialists1089522_a_erialists
immaterialists1883512immaterialists
materialise1347832materialis_e
materialised1555472materialised
materialism1548262materialis_m
materialistic1774012materialistic
materiality1656072materiali_ty
materializes2347222materializes
paternalists1456162paternalists
aerialist9914263_a_erialist_
immaterialisms1793833immaterialisms
immaterialist1794133immaterialist_
imperialists16105403imperialists
literalists1148073liter_alists
madrigalists1672313ma_drigalists
manorialisms1664483manorialisms
materialising16114493materialising
materialities1566393materialities
materialize2247883materiali_ze
materialized2446553materialized
materializer2355363materializer
materializers2453173materializers
materialness1454663materialness
materials11510793material___s
memorialists1654663memorialists
naturalists1146443natur_alists
paternalisms1656083paternalisms
paternalist1358593paternalist_
serialists10810363__serialists
antirealists1297464antirealists
arbalists1148484_a__rbalists
atonalists1048494_at_onalists
clericalists16124154_clericalists
dematerializes26134824dematerializes
editorialists1463414editorialists
externalises1955464externalises
externalisms2154954externalisms
fatalists12310024fat___alists
federalists1544754feder_alists
fraternalisms1863794fraternalisms
generalists12136944gener_alists
herbalists1546194__herbalists
immaterialism16104094immaterialis_m
immateriality2062634immateriali_ty
immaterializes2793364immaterializes
imperialisms18105904imperialisms
imperialist15107774imperialist_
internalises12149114internalises
lateralizes2048434later_alizes
liberalists1346404liber_alists
literalisms1357704liter_alisms
literalist10411534liter_alist_
madrigalist1583134ma_drigalist_
manorialism1574984manorialis_m
marimbists1652244ma__rimbists
material10314104material____
materializing2595974materializing
materially1548004material__ly
materialnesses1653914materialnesses
materiels1147834materiel___s
maximalists2253104ma_ximalists
medalists1249374m__e_dalists
memorialises1655544memorialises
memorialist1556564memorialist_
mentalists12410484m__entalists
metalists11412664m__e_talists
mineralises1357874miner_alises
moralists11311104m__or_alists
muralists1148164m__ur_alists
mutualists1244854mut__ualists
nationalists122010334nationalists
naturalises1146494natur_alises
naturalisms1346504natur_alisms
naturalist1048874natur_alist_
pastoralists1454954pastor_alists
paternalism1556774paternalis_m
paternalistic1753264paternalistic
pictorialists1774114pictorialists
racialists1247704ra__cialists
rationalists121910064rationalists
rematerializes25144694rematerializes
serialises10811564__serialises
serialisms12610274__serialisms
serialist9715114__serialist_
specialists1546204_specialists
sterilises1048254_steri_lises
tribalists1286944__t_ribalists
verbalists1546154__verbalists

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 Filter1786911247900.403443402.0
2DLD Change Limit124790928.06315476.9
3Display Results92920.0462000.0
 (SQL Overall)178691928.51220992.8
 
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.