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

55 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
tabanids114496(None) 
tabanid1047331tabanid_
tabards10310382taba_rds
tabloids1146162tabloids
abasias9711013_abasias
abatis84317933_abati_s
acarids105312243_acarids
agamids11317013_agamids
alands75418373_alan_ds
alanins7315803_alanins
aramids102810513_aramids
araneids947743_araneids
bands85233423__ban_ds
cabanas112413033caban_as
canids95118133__canids
carabids1338193carabids
carangids1344573carangids
cyanids13297933_cyanids
gazanias1845733gazanias
hatbands1446293hatban_ds
iguanids1042913iguanids
labroids1155843labroids
navaids1134803nava_ids
paranoids1248913paranoids
ranids75118703__ranids
ratanies8312923ratanies
ribands10208393riban_ds
robands10219863roban_ds
siganids1045303siganids
tabard9313333taba_rd_
tabarets10287233tabarets
tabbies112913503tab_bies
tabbis102910863tab_bi_s
tabetics1245683tabetics
tabid84418263tab__id_
tabloid1048263tabloid_
taborins103310223taborins
tabulis938833tabuli_s
tabuns8489223tabun__s
tachinids1544043tachinids
taenias7311283ta_enias
tahinis1048013tahini_s
tamandu1044433taman_du
tamandus1143943tamandus
tamarinds1244163tamarinds
tamarins10310843tamarins
tamaris9413593tamari_s
tannins72813223ta_nnins
tarantas839193tarantas
tatamis939723tatami_s
tawnies102812503ta_wnies
tetanics10127373tetanics
tetanies8513553tetanies
titanias847103titanias
triacids1146723triacids

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.1531167915.0
2DLD Change Limit146162556.75321644.0
3Display Results55550.0134230.8
 (SQL Overall)178691556.91925826.1
 
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.