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

129 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
violations133796(None) 
violation1238441violation_
dilations102614452di_lations
etiolations1147392etiolations
illations9311392_illations
iodations1039112_iodations
isolations10310692isolations
solations9814622_solations
vallations1339082vallations
vibrations15157372vibrations
violating1337432violati_ng
violators1246582violat_ors
vitiations1338742vitiations
vocations141911422v_ocations
volitions1288662v_olitions
volutions12108392v_olutions
ablations11311503_ablations
abolitions1246653abolitions
acylations1547603acylations
adorations11310233adorations
adulations11310123adulations
alations82518893__alations
aviations12311553avi__ations
avocations15168683avocations
bilocations1545293bilocations
chelations1539073chelations
ciliations121111003ciliations
citations11312503ci_tations
collations12312853collations
conations111318903_conations
dealations11311373dealations
deflations1439713deflations
delations102616593_delations
desolations12310593desolations
dictations1389703dictations
dilation92215463di_lation_
dilutions10248583di_lutions
donations101112353_donations
dotations101411633_dotations
elations83719123__elations
emulations12310943emulations
epilations12311713epilations
etiolation1048533etiolation_
evocations15259873evocations
evolutions13107043evolutions
fellations1338063fellations
filiations13119093filiations
fixations1936353fi_xations
flotations1366873flotations
foliations1399943_foliations
gelations102513093_gelations
halations12312393_halations
himations1438803hi_mations
ideations1039903_ideations
illation8311943_illation_
immolations1545463immolations
inflations13310323inflations
insolations1149183insolations
iodation9310383_iodation_
isolation9311643isolation_
lallations1038743lallations
libations112510443li_bations
librations12149063librations
ligations102111993li_gations
lineations1039543lineations
liquations1945623liquations
lobations11219613_lobations
locations112512743_locations
migrations13168683migrations
nictations1278313nictations
nidations1039213ni_dations
nitrations10312033nitrations
notations91512973_notations
novations12139003_novations
oblations1139363_oblations
orations81515803__orations
ovations11149263__ovations
ovulations1337973ovulations
ozonations1945143ozonations
phonations1538313phonations
pinnations1236883pinnations
pixilations2045333pixilations
potations111615073_potations
probations14311073probations
pronations12314033pronations
prorations12314463prorations
quotations19146283quotations
reflations13311233reflations
relations92418333_relations
rogations101510823_rogations
rotations91613843_rotations
scalations1239783scalations
sibilations13127933sibilations
siltations1038553siltations
simulations1368393simulations
sinuations1039413sinuations
situations1038433situations
solation8916153_solation_
solutions988883_solutions
solvations1336833_solvations
spoliations1347693spoliations
sublations12410113sublations
titrations1039173titrations
ululations1037143ululations
vacations141910553v_acations
vacillations1744873vacillations
vacuolations1743773vacuolations
vallation1239743vallation_
valuations1348783valuations
variations13310773variations
venations12311723v_enations
vernations13310333vernations
vexations1937753v_exations
vibration14138203vibration_
villains1138003villa_i_ns
violaceous1552883violaceous
violaters1245963violat_ers
violates11311193violat__es
violative1545113violati_ve
violator1146283violat_o_r
violins10311453viol__i_ns
visitations1447673visitations
vitiation1239563vitiation_
vocation132311983v_ocation_
volatiles1246133v_olatiles
volition1179173v_olition_
volutins1188003v_oluti_ns
volution1198603v_olution_
zonations18139313_zonations

Search took 6 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 Filter1786911406030.1561145455.1
2DLD Change Limit1406031295.47025704.4
3Display Results1291290.0602150.0
 (SQL Overall)1786911295.68631426.5
 
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.