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

112 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
vitiations133874(None) 
vitiation1239561vitiation_
ciliations121111002ciliations
citations11312502cit_ations
filiations13119092filiations
initiations11410722initiations
litigations1247332litigations
mitigations1447622mitigations
nitrations10312032nitrations
satiations10312112satiations
situations1038432situations
titivations1446262titivations
titrations1039172titrations
variations13310772variations
vibrations15157372vibrations
violations1337962violations
visitations1447672visitations
vitiating1338402vitiati_ng
vitiators1246922vitiat_ors
activations1669263activations
actuations1239293actuations
agitations11310063agit_ations
aviations12311553_aviations
cavitations1647843cavit_ations
ciliation111112493ciliation_
citation10314363cit_ation_
deviations14311163deviations
dictations1389703dictations
dilations102614453di_lations
divinations15128413divinations
dotations101411633dot_ations
estimations1349943estimations
estivations1449273estivations
expiations1959663expiations
fetations12511383fet_ations
filiation121110243filiation_
filtrations1445623filtrations
fixations1936353fi_xations
foliations1399943foliations
guttations1145593guttations
himations1438803hi_mations
ideations1039903_ideations
illations9311393_illations
imitations1259963_imitations
initiation10412103initiation_
intimations13411883intimations
invitations1449053invit_ations
iodations1039113_iodations
iterations10413823_iterations
levitations1448293levit_ations
libations112510443li_bations
librations12149063librations
ligations102111993li_gations
limitations1348183limitations
lineations1039543lineations
liquations1945623liquations
literations11610583literations
litigation1148173litigation_
mediations13310983mediations
migrations13168683migrations
mitigation1348643mitigation_
motivations1647093motivations
mutations111211453mut_ations
mutilations1348643mutilations
natations91412493nat_ations
nictations1278313nictations
nidations1039213ni_dations
nitration9313443nitration_
notations91512973not_ations
nutations91411763nut_ations
obviations1545463obviations
patinations13411003patinations
petitions11511083peti_tions
pinnations1236883pinnations
pixilations2045333pixilations
potations111615073pot_ations
radiations11311923radiations
rotations91613843rot_ations
satiation9313433satiation_
seriations10316683seriations
sibilations13127933sibilations
siltations1038553siltations
sinuations1039413sinuations
situation949423situation_
stations82415223_st_ations
stictions1148353_stictions
striations10312793striations
titillations1244443titillations
titivation1347033titivation_
titration9310543titration_
unitizations2147453unitizations
urtications1348033urtications
vacations141910553v_acations
validations1547243validations
vallations1339083vallations
valuations1348783valuations
variation12312393variation_
venations12311723v_enations
ventilations1547403ventilations
vernations13310333vernations
vexations1937753v_exations
vibration14138203vibration_
vindications1845683vindications
violation1238443violation_
visitation1348593visitation_
vitalizations25410323vitalizations
vitamins1347083vit_ami_ns
vitiates112311433vitiat__es
vitiator1147043vitiat_o_r
vitrains1138283vitra_i_ns
vocations141911423v_ocations
volitions1288663voli_tions

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.483369960.7
2DLD Change Limit1406031125.43625865.2
3Display Results1121120.0631777.8
 (SQL Overall)1786911125.98229871.4
 
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.