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

50 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
spambots144331(None) 
spambot1345911spambot_
sabots8314702s_a_bots
sambos104315192s_ambo_s
sjamboks2342232sjamboks
abbots1039283__abbots
ambits103713413__ambits
ambos95321253__ambo_s
bamboos1348753_bamboos
cramboes1436543cramboes
crambos1336783crambo_s
gambits12399723_gambits
gambols1238593_gambols
jabots1538883_ja_bots
mamboes135011823_mamboes
mambos125414493_mambo_s
parrots9312743_parrots
psammons1442783psammons
sabbats1138633s_abbats
sabot7931783s_a_bot_
sacbuts1166473s_acbuts
sagbuts1065223s_agbuts
sambals115213483s_ambals
sambars115113843s_ambars
sambas104219263s_amb_as
sambo95118013s_ambo__
samburs11369343s_amburs
samlets93813553s_amlets
seaboots1047093seaboots
shallots11319503shallots
shambles15159043shambles
shammos14307203shammo_s
shamois123210423sham_ois
shamos114216983sham_o_s
shamoys15367283sham_oys
shampoos1544603shampoos
sjambok2242303sjambo_k
spacious1237813spacious
spaits85017473spa__its
spammers14378693spammers
spams94922193spam___s
sparrows1344803sparrows
spats75031383spa___ts
spigots1037793sp_igots
spots74424113sp___ots
spumous1135853spum_ous
steamboats1452493steamboats
subabbots1241873subabbots
symbiots1573623s_ymbiots
symbols1435523s_ymbols

Search took 10 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.420425454.8
2DLD Change Limit146162508.86016496.8
3Display Results50500.0163125.0
 (SQL Overall)178691509.29619222.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.