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

153 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
rattail73780(None) 
cattail939181cattail
rattails837131rattails
attain6311752_attain
brantail1046892brantail
cattails1038552cattails
coattail1045312coattail
fantail10310232fantail
ramtil8311032ramt_il
ratal55025112ra_ta_l
rattailed1084212rattailed
rattan63613602ratta_n
rattans73411952rattans
reattain846732reattain
redtail858712redtail
retail65522072r_etail
wagtail1145042wagtail
agnail739533_agnail
artal55525473_arta_l
assail6610153_assail
atlatl637873_atlatl
atrial65418943_atrial
attach11118393_attach
attack12148153_attack
attagirl942033_attagirl
attains7310983_attains
attaint7313473_attaint
attar56516693_atta_r
attars64515313_attars
attic75618353_att_ic
attrit6315753_attrit
atwain937813_atwain
avail8313883_a_vail
bangtail1144353bangtail
battalia1045293battalia
battik1238093batt_ik
bobtail1146553bobtail
brantails1146313brantails
broadtail1243123broadtail
camail10314833ca_mail
cantal84122033canta_l
captain112111063captain
catcall1139153catcall
catfall1237393catfall
cattalo938423cattalo
cattie85221023catt_ie
cattily123210853catt_ily
coattails1144853coattails
curtail9299663curtail
detail74516433_detail
entail61114343_entail
fantails1139693fantails
fatal84819373fa_ta_l
fattily13379463fatt_ily
foxtail1745383foxtail
fractal1237623fracta_l
graymail1443273graymail
hartal9415473harta_l
lattin64316223latt_in
martial92415413martial
mattin84416633matt_in
mattoid1079283mattoid
natal53921493na_ta_l
nattily103610323natt_ily
outsail71411413outsail
oxtail1337653_oxtail
partial92616263partial
pastil85018323past_il
pattie84020963patt_ie
pigtail1046623pigtail
pintail9311183pintail
pratfall1344153pratfall
rachial122012173rachial
racial83419243racia_l
radial74020393radia_l
ragtag836643ragta_g
ragtags935373ragtags
rail46147763r___ail
raita54623073raita__
raitas64417673raita_s
ramal74622243ra_ma_l
ramtils938413ramt_ils
rascal8511123rasca_l
ratable91717553ra_table
ratably121711513ra_tably
ratafia1045773ratafia
ratals64219583ra_tals
ratan53722663ra_ta_n
ratans63819373ra_tans
ratany93411873ra_tany
ratatat7412263ratatat
ratatats846063ratatats
ratbag956563ratba_g
ratbags1035763ratbags
rateable10311443rateable
rateably1337783rateably
ratel54224883ra_t_el
ratio55227583ra_t_io
ratlin64116523ra_tlin
ratted74923343ratt_ed
ratteen7329113ratteen
ratten64217383ratt_en
rattens74213403rattens
ratter64326313ratt_er
ratters74422473ratters
rattier74015593rattier
ratting83822363ratting
rattish10510823rattish
rattle64717613ratt_le
rattled84012953rattled
rattler74012743rattler
rattles73217303rattles
rattling92510873rattling
rattly94111543ratt_ly
ratton64116123ratt_on
rattons73815323rattons
rattoon7359243rattoon
rattrap945263rattrap
rattraps1044823rattraps
ratty84819593ratt__y
reassail845753reassail
reattach1343743reattach
reattack1444123reattack
reattains946443reattains
reavail1035643reavail
rectal84418133recta_l
redtails968003redtails
remail85017123r_email
renail65020763r_enail
rental63922023renta_l
resail64418733r_esail
retails74718973r_etails
retain64523283r_etain
retial64724993retia_l
retotal739843retota_l
retrain7615423retrain
retral64419743retra_l
retrial7615553retrial
rictal83113183ricta_l
ringtail944723ringtail
ritual6310623ritua_l
ruttily10338613rutt_ily
statal61613223stata_l
tail45443653___tail
tattie64817513tatt_ie
tattily10409993tatt_ily
trail55126773__trail
travail1036553tra_vail
ventail10310453ventail
wagtails1244443wagtails
wassail1056133wassail
wattage1186983wattage
wattape12135383wattape

Search took 10 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.423422437.4
2DLD Change Limit1340271538.47015823.7
3Display Results1531530.436350.9
 (SQL Overall)1786911539.32919154.4
 
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.