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

211 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
ventail1031045(None) 
aventail1145341aventail
entail61114341_entail
ventails1139821ventails
aventails1244992aventails
centai84814782centai_
cental84420962centa_l
dental74319172denta_l
dentil74017882dent_il
detail74516432de_tail
entails7912822_entails
entoil6912492_entoil
fantail10310232fantail
gentil74115122gent_il
lentil64315392lent_il
mental84521602menta_l
pintail9311182pintail
redtail858712redtail
renail65020762ren_ail
rental63922022renta_l
retail65522072re_tail
tenail64516112ten_ail
venal85523212ven_a_l
venatic12311522venatic
venial94218282venia_l
ventage11109622ventage
ventral103612172ventral
vestal94615572vesta_l
agential958153agential
agnail739533agn_ail
bangtail1144353bangtail
bedrail1037253bedrail
benthal1247953benthal
benthic1437473benthic
benzal1739643benza_l
bestial9311643bestial
bewail1189583be_wail
bobtail1146553bobtail
brantail1046893brantail
cantal84122033canta_l
cattail939183cattail
centals94317053centals
centare93113703centare
centas85020703centa_s
centaur935783centaur
centavo1245103centavo
centile94217183cent_ile
central93114473central
centric11312403centric
certain92612213certain
contain9315833contain
contrail10410983contrail
curtail9299663curtail
deltaic1037023deltaic
denial74720513denia_l
dentalia947533dentalia
dentally121110063dentally
dentals83915393dentals
dentate8315153dentate
dentils84115583dent_ils
dentin73919573dent_in
dentoid9310663dentoid
derail74218813de_rail
destain8412083destain
details84214043de_tails
detain74617383de_tain
disentail1047083disentail
dovetail1244393dove_tail
email74715103_e_mail
enatic8317563_enatic
engrail846263_engrail
entailed989523_entailed
entailer877833_entailer
entasia73110063_entasia
entasis73012573_entasis
entia5318203_ent_ia
entoils7810733_entoils
entrails8310163_entrails
entrain7313073_entrain
evenfall1492943evenfall
eventful1443563eventful
eventual1144883eventual
fantails1139693fantails
fentanyl1442533fentanyl
festal94213563festa_l
fetal85623373fe_ta_l
fetial95716193fe_tial
fontal9313143fonta_l
foxtail1745383foxtail
genial74917613genia_l
genital849793genita_l
genteel836753genteel
gentian8310103gentian
gentile83515293gent_ile
horntail11105033horntail
jezail2234643je_zail
lentic83515743lent_ic
lentils73912973lent_ils
lentoid8310683lentoid
meatal84114733meata_l
menial84223033menia_l
mensal84615663mensa_l
menta74424423menta__
mentally131010403mentally
menthol1236733menthol
metal75427383me_ta_l
nail45838653__n_ail
omental93210423omenta_l
overtoil1137453overtoil
oxtail1337653_oxtail
penal75228373pen_a_l
pencil103712973pen_cil
penial84120893penia_l
penicil1138833penicil
pensil83013333pen_sil
pentacle1239383pentacle
pentad9313763penta_d
pentads1039523pentads
pentane9415743pentane
pentanol1046173pentanol
pentyl1138813pent_yl
pertain92714963pertain
petal76526893pe_ta_l
pigtail1046623pigtail
pintails10310163pintails
pontil8315463pont_il
ponytail1344553ponytail
rattail737803rattail
reavail1035643reavail
rectal84418133recta_l
redtails968003redtails
remail85017123re_mail
renails74917263ren_ails
renal55929503ren_a_l
rentable101716333rentable
rentals74017473rentals
resail64418733re_sail
retails74718973re_tails
retain64523283re_tain
retial64724993re_tial
ringtail944723ringtail
sendal73314993senda_l
senti56226703sent_i_
septal84513383septa_l
serail64222673se_rail
setal56430903se_ta_l
sextain14257103sextain
snail57020203_sn_ail
tail45443653___tail
tectal83713253tecta_l
tenails73713923ten_ails
tendril836783tendril
tentacle1037693tentacle
tentage81010643tentage
tentie62521183tent_ie
tertial7313863tertial
toenail738783toen_ail
trenail7410813tren_ail
unnail6410583_unnail
until53517743_unt_il
vail75432553v___ail
vandal103713833vanda_l
vantage11109893vantage
veal76936813ve__a_l
vegetal1156303vegeta_l
veil75523593ve___il
veinal93812963veina_l
vena76126293ven_a__
venae85920983ven_a_e
venally13119563ven_ally
venatical1446793venatical
venation11513503venation
vendable14159693vendable
vendace1357363vendace
venetian1146073venetian
venially1499423venially
venin85118663ven__in
vent76049053vent___
ventages12119773ventages
vented104617923vent_ed
venter94218723vent_er
venters103717733venters
venting114218093venting
ventrally1547253ventrally
ventrals112910003ventrals
ventricle1444383ventricle
vents86125933vent__s
venture10311173venture
venturi1037203venturi
venturis1138193venturis
verbal112513663verba_l
vermeil1285223vermeil
vernal93514213verna_l
versal93013753versa_l
verticil1366913verticil
vervain1335563vervain
vesta86618303vesta__
vestally1437413vestally
vestals104612333vestals
vestas95916683vesta_s
vestral104111013vestral
vexil1538963ve__xil
vinal85725813vin_a_l
vineal94814743vinea_l
vintage11128143vintage
vital84819673v_ita_l
voltaic1245453voltaic
wagtail1145043wagtail
xenial133414903xenia_l
yenta83917043yenta__
yentas94614213yenta_s

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.393454684.5
2DLD Change Limit1340272117.06318975.9
3Display Results2112110.0762776.3
 (SQL Overall)1786912117.53223724.2
 
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.