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

73 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
foxtails184458(None) 
foxtail1745381foxtail_
oxtails1436381_oxtails
bobtails1245192bobtails
fantails1139692fantails
oxtail1337652_oxtail_
bobtail1146553bobtail_
boxballs19144233boxballs
boxhauls2042073boxhauls
cattails1038553cattails
coattails1144853coattails
cocktails1744933cocktails
contains10316533contains
contrails11410543contrails
curtails10318243curtails
details84214043_details
dovetails1343813dovetails
entails7912823_entails
fails85631483f___ails
fantail10310233fantail_
fetials103711743f_etials
fewtrils1443203fewtrils
fishtails1543663fishtails
fixatifs2162073fixatifs
flails94313003f__lails
foals85721693fo__a_ls
foetal9311883foeta_l_
foils85025813fo___ils
fontal9313143fonta_l_
fontanels1244063fontanels
footages1239053footages
footballs1445363footballs
footfalls1544593footfalls
foothill1444993foothill
foothills1544133foothills
footies103721543foot_ies
footsies1139643footsies
footwalls1544383footwalls
foresails1247153foresails
formals123312893forma_ls
forties104323863fort_ies
fortis95418613fort_i_s
fossils10379013fo_ssils
fountains1245283fountains
foxily1947253fox__ily
foxskins2242883foxskins
foxtrots1843923foxtrots
frails93716473f__rails
frontals1146273fronta_ls
hobnails1343303hobnails
horntails12124823horntails
mocktails1743393mocktails
mortals93914003morta_ls
nostrils848183nostrils
obtains939163_obtains
outsails8139863_outsails
oxalis1339223_ox_alis
pigtails1146033pigtails
pintails10310163pintails
pontils9312213pont_ils
ponytails1443653ponytails
portals94015563porta_ls
postals93716373posta_ls
rattails837133rattails
redtails968003redtails
retails74718973_retails
sextains15246813sextains
tails55634193___tails
toenails847213toenails
topsails1075093topsails
totals63115163to_ta_ls
ventails1139823ventails
wagtails1244443wagtails

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.406440125.6
2DLD Change Limit146162736.39022873.6
3Display Results73730.0332212.1
 (SQL Overall)178691736.82926166.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.