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

64 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
araneids94774(None) 
araneid8310801araneid_
aramids102810512ara_mids
araneidan1053032araneidan
carangids1344572carangids
paranoids1248912paranoids
ranids75118702_ran_ids
acarids105312243aca_rids
adenoids1056863adenoids
agamids11317013aga_mids
alands75418373alan__ds
alanins7315803alan_ins
annelids946233a_nnelids
arabesks1442743arabesks
araceous1049183araceous
arachnids1574303arachnids
arachnoids1663373arachnoids
arames84622573arame__s
aramid93315613ara_mid_
arenes64928393arene__s
aroids75118223ar__oids
arsenics1056763arsenics
arsenide9116333arsenide
arsenides1095613arsenides
braids95015693bra__ids
brandies11714563brandies
brands95118943bran__ds
candids113812693_candids
canids95118133_can_ids
carabids1338193cara_bids
carangid1246423carangid_
craned96121653crane_d_
cranes84330753crane__s
crannies10313013crannies
crinoids1147373crinoids
cyanids13297933cyan_ids
ganoids939333_ganoids
grandads1136553grandads
grandkids1643143grandkids
grands84218243gran__ds
grannies9312613grannies
mantids103113623_mantids
maravedis1542963maravedis
muraenids1242743muraenids
paranoias11410443paranoias
paranoics1347653paranoics
paranoid11311143paranoid_
proteids11259953proteids
raids65827513_ra__ids
rancid9513863_rancid_
randies84225663_randies
rands65930453_ran__ds
ranees64623963_rane_es
ranid66429333_ran_id_
ranis55235833_ran_i_s
rapids94913893_ra_pids
tabanids1144963taban_ids
tineids8337873_tineids
tracheids1545053tracheids
trannies8415013trannies
transits8313503transits
uranias72113813uran_ias
uranide82212093uran_ide
uranides92211283uran_ides

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.423422437.4
2DLD Change Limit146162647.40619735.6
3Display Results64640.0134923.1
 (SQL Overall)178691647.84222786.4
 
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.