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

51 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
annelids94623(None) 
annelid838731annelid_
annelidan1052612annelidan
annelidans1151872annelidans
abelias93213563a_belias
adenoids1056863adenoids
amnesias1047833amnesias
amnesics1255283amnesics
anaemias1069203anaemias
androids1047753androids
aneled74719273a_neled_
aneles64626293a_nel_es
aneling82719503a_neling
anemias92512143a_nemias
aneroids9310203aneroids
angeled93211503angeled_
angelic1039623angeli_c
angelica1145893angelica
angelicas1244583angelicas
angeling102811733angeling
angels74416173angel__s
angelus8418463angel_us
anilins7416793a_nilins
annalist8413753annalist
annalists949063annalists
annals66415923annal__s
annealed936333annealed_
annealers944563annealers
annealing1047453annealing
anneals7449943anne_als
annexed1535753annexed_
annexes1437203anne_xes
annexing1635473annexing
annulets845813annulets
annuli6459053annuli__
annuls64711733annul__s
annulus7426613annul_us
antacids1148333antacids
antherids1368723antherids
araneids947743arane_ids
camelids1356943camelids
cannelons1145213cannelons
cannels93413363cannel__s
canneries11313083canneries
cannolis1037863cannoli_s
enneads834733enne_ads
eyelids1135943_eyelids
felids103111623__felids
invalids1244743invalids
tanneries9310423tanneries
tineids8337873tine_ids

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 Filter1786911461620.1561145455.1
2DLD Change Limit146162517.61019206.6
3Display Results51510.0301700.0
 (SQL Overall)178691517.79622920.9
 
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.