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

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

88 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
atheisms134692(None) 
atheism1248521atheism_
atheists1138711atheists
theisms1237761_theisms
ableisms1245412ableisms
ageisms1056602a_geisms
atavisms1346992atavisms
atheist10314062atheis_t
atomisms12269572atomisms
ditheisms1544892ditheisms
pantheisms1745072pantheisms
theism1139482_theism_
theists1039152_theists
ableism1136823ableism_
ableists1036543ableists
actinisms1398883actinisms
activisms16106393activisms
ageism968803a_geism_
ageists848493a_geists
agisms9399393a__gisms
alienisms1146703alienisms
allelisms1156003allelisms
altruisms1144373altruisms
animisms12328393animisms
anthems12309423anthe__ms
antheses11311473anthe_ses
anthesis11312503anthe_sis
apheses12610703aphe_ses
aphesis12610513aphe_sis
aphorisms1647193aphorisms
archaisms1646073archaisms
asterisms11511063asterisms
atavism1238033atavism_
atavists1137583atavists
atheistic1447353atheistic
athelings1345113athelings
atheneums1452513atheneums
atheroma1354873atheroma
atheromas1444983atheromas
athetoses1244973athetoses
athetosis1244643athetosis
atomises103514403atomises
atomism112610963atomism_
atomists102610963atomists
atresias839473atresias
atriums939043at_riums
atropisms1347113atropisms
attests7278813atte_sts
atticisms1367413atticisms
autecisms1346033autecisms
autisms94311553a_utisms
autoecisms1444243autoecisms
casteisms1345253casteisms
chemisms17278213_chemisms
chrisms1499143_chrisms
deisms94411043__deisms
ditheism1446053ditheism_
ditheists1345573ditheists
echoisms1546143echoisms
etatisms1038293etatisms
fatalisms1439113fatalisms
fideisms1444453fideisms
heathenisms1953663heathenisms
heists96814633__heists
lathyrisms1853043lathyrisms
machoisms1845193machoisms
nativisms14105993nativisms
naturisms1146703naturisms
ogreisms1144113ogreisms
pantheism1645653pantheism_
pantheists1546123pantheists
satanisms1148143satanisms
schisms1437173sch_isms
seisms84912143__seisms
statisms1039543statisms
tachisms1567143tachisms
thairms1244453_thairms
theines104013233_theines
theins95015423_thei_ns
theirs94610353_thei_rs
theist9314763_theis_t
therms115914873_the_rms
theses96517973_the_ses
thesis94913733_the_sis
thesps11448263_the_sps
tritheisms1543943tritheisms
truisms9106823_truisms
utopisms1245413utopisms

Search took 7 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 Filter1786911461620.406440125.6
2DLD Change Limit146162886.37622923.8
3Display Results88880.0302933.3
 (SQL Overall)178691886.81226231.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.