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 “violaters” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

94 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
violaters124596(None) 
violater1137251violater_
violates11311191violate_s
violators1246581violators
dilaters92513062di_laters
idolaters1045712idolaters
villagers13296152villagers
violate10311552violate__
violated1237882violate_d
violator1146282violator_
zoolaters1844982zoolaters
bilayers13296923bi_layers
billeters1136873billeters
biometers1339173biometers
bloaters103311023blo_aters
boaters93419243_bo_aters
bolsters103712453_bolsters
bolters94017803_bol_ters
cholates132414763cholate_s
coaters93525793_co_aters
colters93522443_col_ters
deflaters13298703deflaters
desolaters1146043desolaters
dilater83515653di_later_
dilates83220663di_late_s
dilators93213203di_lators
diluters9288113di_luters
diopters1137693dio_pters
elaters74420193__elaters
etiolates949213etiolate_s
figeaters1345753figeaters
filters103816553fi_l_ters
floaters112711513flo_aters
folates103218453_folate_s
gloaters9288863glo_aters
holsters113211943_holsters
idolater936863idolater_
idolators1046283idolators
inflaters1247543inflaters
inlayers1135643_inlayers
iodates8312903_iodate_s
iolites73819483_iolite_s
isolates8613513isolate_s
isolators947513isolators
jilters144211963ji_l_ters
jolters143711993_jol_ters
kiloliters1442933kiloliters
kilters113813603ki_l_ters
locaters102710073_locaters
milters93619093mi_l_ters
misalters1136913misalters
mislayers1445943mislayers
molters93816973_mol_ters
niobates1037283niobate_s
oaters65029793__o_aters
pilasters1138223pi_lasters
pillagers12276923pillagers
platers93924093__platers
relaters83218153_relaters
reviolates1347533reviolate_s
rioters73615523rio__ters
slaters73123733__slaters
solacers10268893_solacers
solates73523853_solate_s
tilters73315953ti_l_ters
variolates1347463variolate_s
vaulters11206173vaul_ters
viators102712023vi__ators
vibrates132210613vibrate_s
vibrators14237253vibrators
vilayets1443073vi_layets
villager12267513villager_
villagery16273363villagery
villages123010603village_s
vintagers13123903vintagers
violaceous1552883violaceous
violas93713523viola___s
violating1337443violating
violation1238443violation
violations1337963violations
violative1545113violative
violets102210003viol__ets
violones1137383violone_s
virgates1237923virgate_s
visiters1137413vi_siters
vitamers1334683vi_tamers
vitiates112311433vitiate_s
vitiators1246923vitiators
voltes94915583v_ol_te_s
volutes102710983v_olute_s
vomiters1337203v_omiters
voters95017443v_o__ters
voyagers1532813v_oyagers
zoolater1746093zoolater_

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 Filter1786911486410.423422437.4
2DLD Change Limit148641947.29620372.9
3Display Results94940.0462043.5
 (SQL Overall)178691947.76523012.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.