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 “antibias” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

104 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
antibias1031208(None) 
actinias101810842actinias
antiboss1047272antiboss
tibias839952__tibias
accidias1346333accidias
actinia91710853actinia_
actiniae101810013actiniae
actinian10209003actinian
actinians11167003actinians
adhibits1443403adhibits
albizias1973533albizias
alibies9313323a_libies
alibis8311073a_libi_s
anabas8314083an_ab_as
anaemias1069203anaemias
analgias9107803analgias
ancillas1048043ancillas
anemias92512143an_emias
anergias947173anergias
angarias9310553angarias
anginas8310953angi_nas
angiomas1145813angiomas
anhingas12104333anhingas
anilins7416793an_ilins
animas84418723an_i_mas
animis84615943an_imi_s
anopias92412483an_opias
anopsias10337983anopsias
anosmias1056083anosmias
anoxias14259113an_oxias
antacids1148333antacids
antas55432033ant___as
antbear935063ant_bear
antbears1044963ant_bears
antennas846403antennas
antiair7310313antiai_r
antiar6317173ant__iar
antiarins9413893antiarins
antiars7314623anti_ars
antibioses1246023antibioses
antibiosis1255943antibiosis
antiblack1744143antiblack
antibodies1346983antibodies
antibody1445343antibody
antibug1045153antib_ug
anticar9312663anti_car
anticity13313603anticity
anticks134612253anti_cks
antics84621453ant__ics
antifat10314253anti_fat
antifoam1347683antifoam
antigay1148223anti_gay
antigens9310603antigens
antijam1648283anti_jam
antiking13412073antiking
antikings1446233antikings
antileak1247173antileak
antilife11410433antilife
antilogs949603antilogs
antiman9313883anti_man
antimask1446573anti_mask
antimine10714753antimine
antings85015583anti_ngs
antipill1046683antipill
antipyics1645653antipyics
antiques1738883antiques
antirabies1248413antirabies
antiriot8414583antiriot
antis55033313ant__i_s
antisag838043anti_sag
antispam1246033antispam
antistat8413793antistat
antistats949233antistats
antitax1447853anti_tax
antiviral1246603antiviral
antivirus1246193antivirus
antiwar1037963anti_war
antiwear1146123antiwear
anurias7312253an_urias
astasias8410143astasias
asterias8317013asterias
astigmias1243463astigmias
ataxias14189343a_taxias
atonias73315993a_tonias
baptisias1344303baptisias
cantinas102713773canti_nas
entasias8269143entasias
entities8617413entities
fantasias1286993fantasias
indicias1147413indicias
inhibins1344893inhibins
inhibits1345203inhibits
intimas9119583inti_mas
mantillas1147043mantillas
mantissas1143873mantissas
nubias8310093_n_ubias
panmixias2042813panmixias
santerias9311843santerias
stibial946583_stibial
tantivies1247103tantivies
tibia7312403__tibia_
tibiae838483__tibiae
tibial849843__tibial
untidies939813untidies

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.423422437.4
2DLD Change Limit1461621046.48322545.4
3Display Results1041040.0462260.9
 (SQL Overall)1786911046.95225703.5
 
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.