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

70 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
wagtail114504(None) 
wagtails1244441wagtails
agnail739532_agnail
bangtail1144352bangtail
cattail939182cattail
fantail10310232fantail
pigtail1046622pigtail
rattail737802rattail
wassail1056132wassail
again65218123_ag_ain
agnails837003_agnails
artal55525473_arta_l
assail6610153_assail
attain6311753_attain
avail8313883_a_vail
bangtails1243593bangtails
bobtail1146553bobtail
brantail1046893brantail
camail10314833ca_mail
cantal84122033canta_l
captain112111063captain
cattails1038553cattails
coattail1045313coattail
curtail9299663curtail
detail74516433_detail
engrail846263engrail
entail61114343_entail
fantails1139693fantails
fatal84819373fa_ta_l
foxtail1745383foxtail
grail64622873__grail
hangnail1253663hangnail
hartal9415473harta_l
hightail1545273hightail
lugsail843443lugsail
martial92415413martial
natal53921493na_ta_l
oxtail1337653_oxtail
partial92616263partial
pastil85018323past_il
pigtails1146033pigtails
pintail9311183pintail
ragtag836643ragta_g
ragtags935373ragtags
ramtil8311033ramt_il
ratal55025113ra_ta_l
rattails837133rattails
redtail858713redtail
retail65522073_retail
ringtail944723ringtail
tail45443653___tail
vagal94613633vag_a_l
ventail10310453ventail
wadmaal1343203wadmaal
wadmal1237283wadma_l
waftage14115323waftage
wail75238823w___ail
wantage11119623wantage
wassails1145953wassails
wastable131410453wastable
wastage11109253wastage
wastrel1037553wastrel
wastrie101210303wastrie
watap102111673wa_ta_p
watape11208483wa_tape
wataps11248683wa_taps
wattage1186983wattage
wattape12135383wattape
waylaid1445093waylaid
whiptail1643283whiptail

Search took 8 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.390458182.1
2DLD Change Limit134027706.97019229.1
3Display Results70700.0135384.6
 (SQL Overall)178691707.37324235.9
 
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.