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

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

42 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
diamagnetisms197175(None) 
diamagnetism1862231diamagnetism_
diamagnetic1752933diamagneti__c
diamagnets1452843diamagnet___s
geomagnetisms1962423geomagnetisms
magnetisms15576693___magnetisms
paramagnetisms2171973paramagnetisms
demagnetizes2552994d_emagnetizes
diamagnet1344954diamagnet____
geomagnetism1862894geomagnetism_
immanentisms1561984_imma_nentisms
magnetises136710094___magnetises
magnetism14567294___magnetism_
paramagnetism2062834paramagnetism_
demagnetize2453425d_emagneti_ze
demagnetized2652835d_emagnetized
demagnetizer2562475d_emagnetizer
demagnetizers2671715d_emagnetizers
diamantes1296265diama_n_t__es
dimerisms1446155di_m___erisms
dismalness1344045dismalne__s_s
dismalnesses1553985dismalne_sses
dogmatisms1643945dogma___tisms
dramatises1356765drama___tises
dramatists1365715drama___tists
ferrimagnetisms2371875ferrimagnetisms
ferromagnetisms23102255ferromagnetisms
giantisms1244815gi__a_n_tisms
gigantisms1453125gi_ga_n_tisms
imagisms1344905_i_mag___isms
immanentism1462455_imma_nentism_
immanentists1662155_imma_nentists
magnesiums1562595___magnesiums
magnetics1447165___magneti_cs
magnetise125110405___magnetis_e
magnetised14506705___magnetised
magnetites138910905___magnetites
magnetizes227910075___magnetizes
mannerisms1455015___mannerisms
paleomagnetisms22121895paleomagnetisms
shamanisms1744085shama_n__isms
tarantisms1245535_tara_n_tisms

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.390458182.1
2DLD Change Limit124790427.90615784.2
3Display Results42420.0162625.0
 (SQL Overall)178691428.31221498.0
 
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.