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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

48 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
antics8462145(None) 
antic75728861antic_
antick124814581antick
anticks134612251anticks
antis55033311anti_s
attics84413281attics
actins86321102actins
anils56326722an_ils
anis45746462an_i_s
antas55432032ant_as
antes56334322ant_es
anti45536362anti__
antiar6317172antiar
antiars7314622antiars
anticar9312662anticar
anticly12410052anticly
anting75827022anting
antings85015582antings
antres65021002antres
ants47243472ant__s
anvils9219712anvils
arctics1138952arctics
asdics9439862asdics
aspics104211562aspics
attic75618352attic_
aunties73920072aunties
banties94324762banties
cantic103920542cantic_
entice81316862entice
entices91616332entices
fanatics1367182fanatics
fanfics1535172fanfics
intis55121642inti_s
manics103919932man_ics
mantic104120902mantic_
mantids103113622mantids
mantis83926032manti_s
mastics112614782mastics
ontic74418572ontic_
optics102810182optics
panics103815362pan_ics
panties94230932panties
quantics19276832quantics
santims9312602santims
santirs7312962santirs
tactics1149322tactics
tics65729632__tics
unties64326922unties

Search took 3 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 Filter178691825510.360496363.9
2DLD Change Limit82551482.26336478.6
3Display Results48480.0163000.0
 (SQL Overall)178691482.63967711.6
 
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.