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

207 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
violated123788(None) 
violate10311551violate_
violater1137251violater
violates11311191violates
dilated93115822di_lated
etiolated1047072etiolated
iodated9310022_iodated
isolated9410522isolated
reviolated1446252reviolated
solated83618022_solated
variolated1445402variolated
vibrated14228392vibrated
violaters1245962violaters
violator1146282violator
vitiated12289222vitiated
voluted11297942v_oluted
ablated102513443_ablated
acylated1437873acylated
adulated1039753adulated
alated75625143__alated
areolated1089713areolated
aviated11310263avi__ated
belated103520013_belated
billeted1137643billeted
bilobated1444973bilobated
bilsted1038033bi_lsted
bloated104513433blo_ated
boated94221973_bo_ated
bolted94617803_bol_ted
borated104116363_borated
bromated1339173bromated
chelated142610483chelated
cholate122114933cholate_
cholates132414763cholates
ciliated11510953ciliated
citrated112712253citrated
coated94927043_co_ated
collated113615063collated
dealated103213603dealated
deflated133412303deflated
delated93722873_delated
desolated1139653desolated
dictated1239203dictated
dilate73220693di_late_
dilater83515653di_later
dilates83220663di_lates
diluted9248933di_luted
disrated10915573disrated
doated84118183_do_ated
donated93513863_donated
elated74725823__elated
emulated11310793emulated
epilated11310753epilated
etiolate849523etiolate_
etiolates949213etiolates
fellated1239563fellated
fileted1159093fi_leted
filiated12610083filiated
filleted1236603filleted
fixated1835533fi_xated
floated113312703flo_ated
folate93320393_folate_
folates103218453_folates
foliated1249913_foliated
gelated93615633_gelated
gimleted1243973gimleted
gloated93511533glo_ated
globated1265753globated
hilted104016043hi_l_ted
ideated9310973_ideated
idolater936863idolater
immolated1444873immolated
inflated12410863inflated
inlaced10239873_inlaced
insolated1039713insolated
inviolate1246393inviolate_
iodate7313503_iodate_
iodates8312903_iodates
iolite63221983_iolite_
iolites73819483_iolites
isleted837523_isleted
isolate7313923isolate_
isolates8613513isolates
jilted144111353ji_l_ted
jolted143510633_jol_ted
kilted113613833ki_l_ted
lated65240673___lated
librated113110313librated
ligated92414143li_gated
ligulated11247363ligulated
lilted73715373li_l_ted
lineated9711063lineated
liquated1835493liquated
lobated102610943_lobated
located103114183_located
migrated121110513migrated
milted93919943mi_l_ted
misdated121211123misdated
mismated131111333mismated
misrated111315383misrated
moated94819003_mo_ated
molted94217473_mol_ted
nictated1137793nictated
nidated939863ni_dated
niobate937703niobate_
niobates1037283niobates
nitrated92213153nitrated
notated82713663_notated
orated74221503__orated
ovulated1237083ovulated
oxalated1695323oxalated
ozonated1864593ozonated
phonated1447893phonated
picrated132110113picrated
pileated112711133pileated
pillaged12298093pillaged
pillared11228093pillared
piloted10310323pi_loted
pinnated11338553pinnated
pirated102515613pi_rated
pixilated1944543pixilated
plated95225773__plated
probated13410863probated
prolate9419793prolate_
pronated11414053pronated
prorated11513713prorated
reflated123514293reflated
related83327573_related
replated112817513replated
reslated93517523reslated
reviolate1248123reviolate_
reviolates1347533reviolates
rioted73416373rio__ted
rotated82715293_rotated
sibilated1246713sibilated
silted74020013si_l_ted
simulated1238283simulated
sinuated938413sinuated
situated938033situated
slated75028313__slated
solaced102911063_solaced
solate64526073_solate_
solates73523853_solates
solvated12237443_solvated
spoliated1246913spoliated
sublated11311503sublated
tilted74616863ti_l_ted
titrated92611683titrated
togated94410663_togated
toileted936993toileted
ululated947663ululated
vacated1349353v_acated
vacillated1654623vacillated
vacuolated1643973vacuolated
valeted1139013v_aleted
vallate103016563vallate_
valuated12239203valuated
variated121211393variated
variolate1248553variolate_
variolates1347463variolates
vaulted11307193vaul_ted
velate93720143v_elate_
vialed105112593vi__aled
vialled1156843vial_led
vibrate122811523vibrate_
vibrates132210613vibrates
vilayet1348533vi_layet
villae95615383villa_e_
village113610833village_
villager12267513villager
villages123010603villages
villatic1346223villatic
viola85915543viola___
violable1337543violable
violably1644923violably
violas93713523viola__s
violating1337433violating
violation1238443violation
violative1545113violative
violators1246583violators
violet92620923viol__et
violets102210003violet_s
violone1037153violone_
violones1137383violones
virgate1138733virgate_
virgates1237923virgates
visaed104110503vi_sa_ed
visaged1235683vi_saged
visited1168773vi_sited
vistaed1138023vista_ed
vitiate103412953vitiate_
vitiates112311433vitiates
vittate10409733vittate_
volante1038513v_olante_
voled95323723v_ol__ed
volte85321303v_ol_te_
voltes94915583v_ol_tes
volumed13285683v_olumed
volute93912763v_olute_
volutes102710983v_olutes
volvate13317993v_olvate_
vomited1337253v_omited
voted93919143v_o__ted
voyaged1533513v_oyaged
wilted103915713wi_l_ted
zonated173310533_zonated
zoolater1746093zoolater

Search took 9 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 Filter1786911461620.1561145455.1
2DLD Change Limit1461622077.89318517.9
3Display Results2072070.0762723.7
 (SQL Overall)1786912078.12521992.7
 
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.