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

195 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
redtail85871(None) 
redtails968001redtails
retail65522071re_tail
bedrail1037252bedrail
detail74516432de_tail
entail61114342_entail
rattail737802rattail
reavail1035642reavail
rectal84418142recta_l
redbait1039802redbait
redial74923112redia_l
remail85017122re_mail
renail65020762re_nail
rental63922032renta_l
resail64418732re_sail
retails74718972re_tails
retain64523282re_tain
retial64724992re_tial
ventail10310452ventail
aventail1145343aventail
bedevil1344513bedevil
bedrails1136293bedrails
bestial9311643bestial
bewail1189583be_wail
bobtail1146553bobtail
brantail1046893brantail
broadtail1243123broadtail
cattail939183cattail
centai84814783centai_
cental84420963centa_l
certain92612213certain
credal9311673cred_a_l
crestal9312133cresta_l
curtail9299663curtail
dedal75719023ded_a_l
deltaic1037023deltaic
dental74319173denta_l
dentil74017883dent_il
derail74218813de_rail
destain8412083destain
details84214043de_tails
detain74617383de_tain
drail65020973__drail
email74715103_e_mail
entails7912823_entails
entoil6912493_entoil
fantail10310233fantail
festal94213563festa_l
fetal85623373fe_ta_l
fetial95716193fe_tial
foxtail1745383foxtail
gentil74115123gent_il
headsail1244423headsail
jezail2234643je_zail
lentil64315393lent_il
meatal84114733meata_l
medal86221333med_a_l
medial93819863media_l
mental84521603menta_l
metal75427383me_ta_l
oxtail1337653_oxtail
pedal86022503ped_a_l
pertain92714963pertain
petal76526893pe_ta_l
pigtail1046623pigtail
pintail9311183pintail
predial103815413predia_l
prevail1238243pre_vail
radial74020393radia_l
rail46147763r___ail
ramtil8311033ramt_il
ratal55025113r_ata_l
rattails837133rattails
real45750293re__a_l
reassail845753reassail
reata54225393reata__
reatas64021013reata_s
reattain846733reattain
reavails1134853reavails
rebait8320403re_bait
reboil83814683re_boil
recall83815733re_call
recital9412173recita_l
reclaim1137753reclaim
recoal84117983recoa_l
recoil84016723re_coil
recta74220263recta__
rectally1339713rectally
recti73619623rect_i_
rectrix1645363rectrix
redact9419043red_act
redan66125013red_a_n
redans75421023red_ans
redate74124683red_ate
redated93120923redated
redates83423873redates
redating102620173redating
redbaits1135903redbaits
redbay1238333redba_y
redbays1336013redbays
redcap1158493redca_p
redcaps1247073redcaps
redear73515173redea_r
redears82814453redears
redfin10310223red_fin
redia65524483red__ia
rediae74221993redia_e
redials84416883redials
redias74523603redia_s
redid74922393red__id
redip87816963red__ip
redpoll1045043redpoll
redraft11310573redraft
redraw10269853redra_w
redrawn11245953redrawn
redraws11218473redraws
redrill857893redrill
redskin1286023redskin
redstart949193redstart
redtop937973redt_op
redtops1037373redtops
redware1139363redware
refall94314393re_fall
refrain10310043refrain
refutal1046943refuta_l
regain74517763re_gain
regal65023793re_ga_l
regnal74812933regna_l
relaid75518443re_laid
remails94714563re_mails
remain85919863re_main
renails74917263re_nails
renal55929513re_na_l
rentable101716333rentable
rentals74017483rentals
reobtain1044623reobtain
reoil55321183re__oil
repaid94716323re_paid
repair84011463re_pair
repeal84718293repea_l
reptant92817073reptant
reptile93914083rept_ile
resaid74517083re_said
resails74616743re_sails
reseal64819653resea_l
restable101618443restable
restack1339433restack
restaff1339013restaff
restage83316193restage
restamp1146483restamp
restart7320033restart
restate73824883restate
restful1038623restful
restrain8311703restrain
retable91820403re_table
retack122612823re_tack
retag63618413re_ta_g
retags73414303re_tags
retailed94113963re_tailed
retailer82911573re_tailer
retailor8285223re_tailor
retains74522253re_tains
retake104718533re_take
retally10413683re_tally
retape83917683re_tape
retard75018933re_tard
retax124517973re_ta_x
retell63813643re_tell
retia55326113re_t_ia
retie55735303re_t_ie
retile65929673re_t_ile
retool63914483re_tool
retotal739843retota_l
retrain7615423retrain
retral64419743re_tral
retrial7615553re_trial
retrim83514883re_trim
reveal94115063revea_l
rictal83113193ricta_l
ridgil8316823rid_gil
ringtail944723ringtail
septal84513383septa_l
serail64222673se_rail
setal56430903se_ta_l
sextain14257103sextain
tail45443653___tail
tectal83713253tecta_l
tenail64516113te_nail
tertial7313863tertial
treenail846123treenail
trenail7410813tre_nail
uredial82910483uredia_l
ventails1139823ventails
vestal94615573vesta_l
wagtail1145043wagtail

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.436409841.7
2DLD Change Limit1340271957.33018284.7
3Display Results1951950.0603250.0
 (SQL Overall)1786911957.82622833.0
 
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.