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

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
animistic136742(None) 
animalistic1555292animalistic
animist93815172animist__
animists103010632animist_s
atomistic1347772atomistic
nomistic1279592_nomistic
activistic1744933activistic
agonistic1246683agonistic
albinistic1454013albinistic
amoristic1347993amoristic
anabiotic1345553anabiotic
anamnestic1453603anamnestic
anapestic1346313anapestic
andesitic1245243andesitic
anelastic1147043anelastic
animalic1258153anim_alic
animis84615943animis___
animism113510213animis__m
animisms12328393animis_ms
animosity1445253animosity
anisic8313793an__is_ic
annalistic1276443annalistic
antibiotic1456623antibiotic
antimitotic1554753antimitotic
antimusic1346263antimus_ic
antistick1548443an_tistick
aoristic10311163a_oristic
apomictic1744183apomictic
armistice1345033a_rmistice
artistic10310893a_rtistic
atavistic1445983atavistic
atheistic1447353atheistic
autistic10310103a_utistic
dynamistic1853343dynamistic
familistic1754653familistic
narcistic1346443narcistic
nativistic1555003nativistic
onanistic1147373onanistic
onomastic1346813onomastic
optimistic1654303optimistic
pacifistic1953823pacifistic
panmictic1744503pan_mictic

Search took 8 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 Filter1786911486410.440406115.9
2DLD Change Limit148641427.20320636.0
3Display Results42420.0301400.0
 (SQL Overall)178691427.67323288.3
 
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.