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

193 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
pintail931118(None) 
pigtail1046621pigtail
pintails10310161pintails
entail61114342_entail
fantail10310232fantail
pigtails1146032pigtails
pinball1137932pinball
pineal84817682pinea_l
pinnal84814272pinna_l
pinta75727052pinta__
pintada1096082pintada
pintado1096572pintado
pintailed1245552pintailed
pintano998992pintano
pintas85021392pinta_s
pistil83915072pist_il
pontil8315462pont_il
ponytail1344552ponytail
ringtail944722ringtail
ventail10310452ventail
agnail739533agn_ail
airmail946213airmail
aventail1145343aventail
bangtail1144353bangtail
binal75323823bin_a_l
bobtail1146553bobtail
brantail1046893brantail
cantal84122033canta_l
cattail939183cattail
centai84814783centai_
cental84420963centa_l
contain9315833contain
contrail10410983contrail
curtail9299663curtail
dental74319173denta_l
dentil74017883dent_il
detail74516433_detail
disentail1047083disentail
distain8313783distain
distal73615773dista_l
distil73616433dist_il
entails7912823_entails
entoil6912493_entoil
fantails1139693fantails
final83922033fin_a_l
finial92814183finia_l
fishtail1443983fishtail
fontal9313143fonta_l
foxtail1745383foxtail
gentil74115123gent_il
gingal81010153ginga_l
gingall9117333gingall
hiatal9310203hiata_l
hightail1545273hightail
horntail11105033horntail
infall939403_infall
inhaul936803_inhaul
initial7311883_initial
inlaid7310143_inlaid
instal6712193_insta_l
install779363_install
instil61111383_instil
intact8314663_intact
intagli845023_intagli
intake10510863_intake
inti46626083_int_i_
intis55121643_int_is
intuit6314083_intuit
inwall938343_inwall
jingal1498593jinga_l
jingall1566173jingall
lentil64315393lent_il
lineal65616023linea_l
lintel64013993lint_el
lintol6369473lint_ol
litai55216363li_tai_
mainsail1045173mainsail
maintain1077723maintain
mental84521603menta_l
mintage101110123mintage
minutial1046423minutial
nail45838653__n_ail
nitril62511533ni_tril
oxtail1337653_oxtail
pail66141833p___ail
paintable1337243paintable
paintball1342663paintball
pantie84326473pant_ie
pantile93918483pant_ile
partial92616263partial
pastil85018323past_il
penal75228373pen_a_l
pencil103712973pen_cil
penial84120893penia_l
penicil1138833penicil
pensil83013333pen_sil
pentacle1239383pentacle
pentad9313763penta_d
pentads1039523pentads
pentane9415743pentane
pentanol1046173pentanol
pentyl1138813pent_yl
pertain92714963pertain
petal76526893p_eta_l
pial65636703pi__a_l
pibal95217323pi_ba_l
pical95524373pi_ca_l
pickadil1742633pickadil
pieta75421753pieta__
pietas84516503pieta_s
pigtailed1353493pigtailed
pina65842633pin_a__
pinang92611593pin_ang
pinas75434453pin_a_s
pinata83817223pin_ata
pinatas93711503pinatas
pinballs1246933pinballs
pineals93212843pineals
pineta85815563pineta__
pinguid1146243pinguid
pinitol936683pinitol
pinkie124414273pin_kie
pinna75320183pinna__
pinnace113510313pinnace
pinnacle12416963pinnacle
pinnae84414643pinna_e
pinnas85315513pinna_s
pinnate93613743pinnate
pint66963173pint___
pintadas11105083pintadas
pintados11105993pintados
pintanos10107553pintanos
pintle83818263pint_le
pintles94118723pintles
pinto75625753pint__o
pintoes95117713pintoes
pintos86021293pint_os
pints75936223pint__s
pintsize1955103pintsize
pinwale1257843pinwale
pinyin112710613pin_yin
pipal95118353pi_pa_l
piratic11314293piratic
pistils93314303pist_ils
pistol83313333pist_ol
pita65436433pi_ta__
pitas77427673pi_ta_s
pitaya1186603pi_taya
pitfall1245823pitfall
pithily1567033pi_thily
pitta75018693pitta__
pittas86014523pitta_s
pivotal1245433pivota_l
plantain1047903plantain
pointable1337343pointable
pontils9312213pont_ils
ponytails1443653ponytails
portal84218463porta_l
postal84317533posta_l
prevail1238243prevail
printable1338203printable
qintar15359143qinta_r
qintars16268573qintars
quintain17316223quintain
quintal16389883quinta_l
rattail737803rattail
redtail858713redtail
renail65020763ren_ail
rental63922023renta_l
retail65522073_retail
rictal83113183ricta_l
ringtails1044443ringtails
snail57020203_sn_ail
spinal84915313spin_a_l
spital83813873spi_ta_l
sprigtail12122773sprigtail
springtail13132333springtail
tail45443653___tail
tenail64516113ten_ail
tincal83913363tinca_l
tineal66216163tinea_l
tinfoil1044633tinfoil
uintaite8127353uintaite
unnail6410583_unnail
until53517743_unt_il
ventails1139823ventails
vinal85725813vin_a_l
vineal94814743vinea_l
vintage11128143vintage
vital84819673vi_ta_l
wagtail1145043wagtail
whiptail1643283whiptail
wintrily1445373wintrily

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.403443402.0
2DLD Change Limit1340271936.03322215.6
3Display Results1931930.0762539.5
 (SQL Overall)1786911936.51227440.3
 
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.