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

92 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
pigtail104662(None) 
pigtails1146031pigtails
pintail9311181pintail
hightail1545272hightail
pigtailed1353492pigtailed
pintails10310162pintails
pistil83915072pist_il
ringtail944722ringtail
sprigtail12122772sprigtail
wagtail1145042wagtail
abigail1044193abig_ail
agnail739533_agnail
airmail946213airmail
bangtail1144353bangtail
bobtail1146553bobtail
cattail939183cattail
curtail9299663curtail
detail74516433_detail
digital937063digita_l
distain8313783distain
distal73615773dista_l
distil73616433dist_il
engrail846263engrail
entail61114343_entail
epigeal1046243epigea_l
fantail10310233fantail
fishtail1443983fishtail
foxtail1745383foxtail
grail64622873__grail
hiatal9310203hiata_l
hightails1645313hightails
litai55216363li_tai_
lugsail843443lugsail
nitril62511533ni_tril
oxtail1337653_oxtail
pail66141833p___ail
partial92616263partial
pastil85018323past_il
pertain92714963pertain
petal76526893p_eta_l
pial65636703pi__a_l
pibal95217323pi_ba_l
pical95524373pi_ca_l
pickadil1742633pickadil
pieta75421753pieta__
pietas84516503pieta_s
piggie103210773pig_gie
piggin103111093pig_gin
pignoli1045443pignoli
pigskin1444353pigskin
pinball1137933pinball
pineal84817683pinea_l
pinnal84814273pinna_l
pinta75727053pinta__
pintada1096083pintada
pintado1096573pintado
pintailed1245553pintailed
pintano998993pintano
pintas85021393pinta_s
pipal95118353pi_pa_l
piratic11314293piratic
pistils93314303pist_ils
pistol83313333pist_ol
pita65436433pi_ta__
pitas77427673pi_ta_s
pitaya1186603pi_taya
pitfall1245823pitfall
pithily1567033pi_thily
pitta75018693pitta__
pittas86014523pitta_s
pivotal1245433pivota_l
pontil8315463pont_il
ponytail1344553ponytail
portal84218463porta_l
postal84317533posta_l
prevail1238243prevail
rattail737803rattail
redtail858713redtail
retail65522073_retail
rictal83113183ricta_l
ringtails1044443ringtails
sigil63515503sig__il
signal73711483signa_l
spital83813873spi_ta_l
sprigtails1382783sprigtails
springtail13132333springtail
tail45443653___tail
ventail10310453ventail
vigil94313003vig__il
vital84819673vi_ta_l
wagtails1244443wagtails
whiptail1643283whiptail

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 Limit134027926.03022226.7
3Display Results92920.0332787.9
 (SQL Overall)178691926.46927622.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.