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

118 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
antisag83804(None) 
antiar6317172anti_ar
antibug1045152antibug
anticar9312662anticar
antifat10314252antifat
antifog1146312antifog
antigang1067402antigang
antigay1148222antigay
antijam1648282antijam
antilog838622antilog
antiman9313882antiman
anting75827022anti_ng
antis55033312antis__
antisex1439692antisex
antismog1144832antismog
antispam1246032antispam
antistat8413792antistat
antitax1447852antitax
antiwar1037962antiwar
artisan759462artisan
actinal9312293actinal
acting95920983acti_ng
aftosa996573aftosa_
aftosas10147153aftosas
angina7413133angina_
anginal8310163anginal
anginas8310953anginas
anhinga11104823anhinga
anima74620073an_ima_
animal85016253an_imal
animas84418723an_imas
anis45746463an_is__
anise55129703an_is_e
anises64826693an_ises
anisic8313793an_isic
ansa45927773an__sa_
ansae55720973an__sae
anta46839583ant__a_
antae56828293ant__ae
antas55432033ant__as
antbear935063antbear
anteing8312813anteing
antes56334323antes__
anthrax1757153anthrax
anti45536363anti___
antiair7310313antiair
antiars7314623antiars
antibias10312083antibias
antic75728863anti__c
antick124814583anti_ck
anticks134612253anticks
anticly12410053anticly
antics84621453anti_cs
antidrug1043833antidrug
antiflu1046683antiflu
antifoam1347683antifoam
antifur1047493antifur
antigen8311123antigen
antigun847963antigun
antiking13412073antiking
antileak1247173antileak
antilogs949603antilogs
antilogy1248103antilogy
antimale10312463antimale
antimask1446573antimask
antings85015583antings
antipot9312923antipot
antique1638883antique
antirape10410113antirape
antired82316193antired
antisera849183antisera
antishark1644163antishark
antiship1348463antiship
antiskid1346673antiskid
antislip1046323antislip
antismut1047703antismut
antisnob1044213antisnob
antisolar9116753antisolar
antistate9410143antistate
antistats949233antistats
antitank1247193antitank
antitragi1045543antitragi
antiwear1146123antiwear
antra56521923ant_ra_
antral65719413ant_ral
ants47243473ant_s__
antsier7410773antsier
antsy85712793ant_s_y
artisans888523artisans
artist64125543artis_t
artiste73813693artiste
artists74215593artists
autism83815333autis_m
autisms94311553autisms
autist64324943autis_t
autists73814853autists
bartisan1056163bartisan
cantina93417253cantina_
cantinas102713773cantinas
canting104725903canti_ng
entia5318203enti_a_
envisage1242653envisage
hanting114124483hanti_ng
incisal947373incisal
intima81910033intima_
intimae9109753intimae
intimal9109943intimal
intimas9119583intimas
intis55121643intis__
mantis83926033mantis__
mantises10317923mantises
mantissa1044573mantissa
mantissas1143873mantissas
panting104025423panti_ng
partisan1058423partisan
ptisan8417973_ptisan
ranting84025413ranti_ng
wanting114220173wanti_ng

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271185.95322514.2
3Display Results1181180.0462565.2
 (SQL Overall)1786911186.40527898.7
 
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.