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

91 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
materiality165608(None) 
immateriality2062632immateriality
materialise1347842materialise
materialism1548272materialism
materialist1349522materialist
materialists1456982materialists
materialize2247892materialize
materially1548012material_ly
externality2155043externality
internality1448683internality
literality1346903liter_ality
material10314113material___
materialised1555473materialised
materialises1447323materialises
materialisms1657303materialisms
materialistic1774013materialistic
materialities1566393materialities
materialized2446553materialized
materializer2355363materializer
materializes2347223materializes
materials11510813material__s
maternally1545763maternal_ly
maternity1444983mater__nity
sterility1247763_steri_lity
aerialist9914264_a_erialist
aerialists1089524_a_erialists
aerially11911914_a_erial_ly
amorality1446724_amor_ality
arterially1347354arterial_ly
asexuality2053784_asexuality
atonality1247074_at_onality
atypicality2152124_atypicality
aurality1139224_a_ur_ality
axiality1856764_a__xiality
bacterially18114974bacterial_ly
carnality1447604ca__rnality
dematerialize25154914dematerialize
ethereality1753164ethereality
exteriority2153684exteriority
extrality1967204ext_r_ality
fatality1438444fat___ality
generality1446194gener_ality
geniality1347164__geniality
immaterialism16104094immaterialism
immaterialist1794134immaterialist
immaterialists1883514immaterialists
immaterialize2673544immaterialize
integrality1554914integrality
interiority1456964interiority
labiality1446364la__biality
lateraling11148804later_aling
lateralize1949054later_alize
laterally1248074later_al_ly
liberality1545904liber_ality
mammality1544284ma__mmality
manorialism1574984manorialism
marginality1754414marginality
materialising16114494materialising
materializers2453174materializers
materializing2595974materializing
materialness1454664materialness
materiel10311264materiel___
materiels1147844materiel__s
maternal1047804maternal___
matriarchy2071614mat_riarchy
maturity1367444matur___ity
mayoralty1752214mayor_al_ty
mentality1449134m__entality
morality131110334m__or_ality
mortality1467734m__ortality
motility1338734mot__i_lity
mutability1748074mutabi_lity
mutuality1444744mut__uality
natality1139194nat___ality
nationality14147934nationality
partiality1546784pa_rtiality
paternalism1556784paternalism
paternalist1358594paternalist
paternalists1456164paternalists
paternally1545864paternal_ly
paternity1444844pater__nity
patriliny1446074pat_ri_liny
potentiality1754334potentiality
puerility1445994_pueri_lity
rationality1458094rationality
rematerialize24144884rematerialize
spatiality1544404spat__iality
speciality1746334_speciality
veniality1547594__veniality
waterily1438794wateri_l__y
waterlily1544354water__lily

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 Limit148819919.34615923.3
3Display Results91910.0461978.3
 (SQL Overall)178691919.81218211.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.