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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

116 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
materialistic177401(None) 
materialist1349512materialist__
materialists1456982materialist_s
paternalistic1753262paternalistic
imperialistic1962943imperialistic
literalistic1454413liter_alistic
materialise1347833materialis__e
materialised1555473materialis_ed
materialises1447323materialis_es
materialising16114493materialising
materialism1548263materialis__m
materialisms1657303materialis_ms
materialities1566393materiali_ties
materiality1656073materiali_t_y
naturalistic1484543natur_alistic
aerialist9914264_a_erialist__
aerialists1089524_a_erialist_s
fatalistic1546714fat___alistic
immaterialist1794134immaterialist__
immaterialists1883514immaterialist_s
liberalistic1653904liber_alistic
materialization2675214materialization
materialize2247884materiali__ze
materialized2446554materiali_zed
materializer2355364materiali_zer
materializers2453174materializers
materializes2347224materiali_zes
materializing2595974materializing
materials11510794material_s___
mentalistic1555984m__entalistic
moralistic1446804m__or_alistic
mutualistic1553344mut__ualistic
nationalistic1595554nationalistic
paternalist1358594paternalist__
paternalists1456164paternalist_s
racialistic1554674ra__cialistic
rationalistic15125454rationalistic
specialistic1854184_specialistic
verbalistic1853864__verbalistic
aeroelastic1354875_a_eroelastic
aerolitic1149345_a_er_oli_tic
animalistic1555295_a_nimalistic
annalistic1276445_a__nnalistic
atavistic1445985_at___avistic
bacteriolytic2261645bacteriol_ytic
cabalistic1645715ca___balistic
cannibalistic1992165cannibalistic
capitalistic1853765ca_pitalistic
catechistic1753135cate__chistic
centralistic1655115centr_alistic
colonialistic1773185colonialistic
commercialistic2292115commercialistic
deterministic1862415deterministic
emotionalistic1862835emotionalistic
familistic1754655fa__mi_listic
feudalistic1753405__feudalistic
formalistic1854345__formalistic
hyperrealistic2462725hyperrealistic
idealistic1344705_ide__alistic
immaterialism16104095immaterialis__m
immaterialisms1793835immaterialis_ms
immaterialities1962875immateriali_ties
immateriality2062635immateriali_t_y
imperialist15107775imperialist__
imperialists16105405imperialist_s
intergalactic1862345intergalactic
journalistic2152775_journalistic
lateritic1147885later___i_tic
legalistic1345275__le_galistic
literalist10411535liter_alist__
literalists1148075liter_alist_s
madrigalist1583135ma_drigalist__
madrigalists1672315ma_drigalist_s
manneristic1553305manner___istic
manorialism1574985manorialis__m
manorialisms1664485manorialis_ms
marlitic1238345ma__r__li_tic
material10314105material_____
materially1548005material___ly
materialness1454665material_ness
materialnesses1653915materialnesses
materiels1147835materiel_s___
mechanistic2054375m__echanistic
mediumistic1851995m__ediumistic
melanistic1445875m__e_lanistic
melioristic1554505m__elioristic
memorialist1556565memorialist__
memorialists1654665memorialist_s
meristic12311255m__er___istic
meroblastic1755285m__eroblastic
modernistic1653015moder__nistic
nativistic1555005nat__i_vistic
naturalist1048875natur_alist__
naturalists1146445natur_alist_s
neorealistic1453475_neorealistic
neutralistic1474145neutr_alistic
nonrealistic1454965_nonrealistic
paternalism1556775paternalis__m
paternalisms1656085paternalis_ms
patristic1389285pat_r___istic
pluralistic1554055_plur_alistic
realistic1148555____realistic
revivalistic2052665__revivalistic
ritualistic1354125rit__ualistic
serialist9715115__serialist__
serialists10810365__serialist_s
socialistic1565815__socialistic
surrealistic1452775_surrealistic
terroristic1354425__terroristic
totalistic1246595__t_otalistic
ultraistic1246375ult_r_a_istic
ultrarealistic16142305ultrarealistic
universalistic1971745universalistic
unrealistic1353985__unrealistic
vandalistic1753985va__ndalistic
vitalistic1545865vit___alistic

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 Filter1786911247900.453394461.4
2DLD Change Limit1247901169.08013743.4
3Display Results1161160.0761526.3
 (SQL Overall)1786911169.60918596.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.