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

123 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
vitiating133841(None) 
filiating1339252filiating
initiating1149622initiating
litigating1246742litigating
mitigating1447432mitigating
nitrating10312672nitrating
satiating10311812satiating
situating1038882situating
titivating1445322titivating
titrating10310112titrating
variating13310952variating
vibrating1537482vibrating
violating1337442violating
visiting1238392visi_ting
vitiation1239562vitiation
vitiations1338742vitiations
activating1647863activating
actuating1239233actuating
agitating1138863agit_ating
antiaging1149673antiaging
aviating12311023_aviating
bitting103717293bit__ting
cavitating1646913cavit_ating
citifying1845383citifying
deviating14311083deviating
dictating1338883dictating
dilating102714913di_lating
disrating11714553disrating
estating92614993est_ating
estimating1348883estimating
estivating1447633estivating
expiating1938543expiating
filtrating1445973filtrating
fitting113516563fit__ting
fixating1936183fi_xating
foliating1339253foliating
gitting93215703git__ting
hitting113017273hit__ting
ideating10311703_ideating
imitating1238763_imitating
initialing1145883initialing
intimating13410823intimating
iodating1038823_iodating
iterating10314253_iterating
kitting123214443kit__ting
lariating10311793lariating
levitating1446653levit_ating
librating1239053librating
ligating102212283li_gating
limiting1138813limi_ting
liquating1946313liquating
mediating13311203mediating
migrating13910533migrating
militating1348823militating
misdating131010663misdating
miseating121215433miseating
mismating141211823mismating
misrating121014853misrating
motivating1646803motivating
mutating112211753mut_ating
mutilating1349083mutilating
nictating1237573nictating
nictitating1444383nictitating
nidating1039783ni_dating
notating92513343not_ating
nutating92411953nut_ating
obviating1545053obviating
opiating11410093_opiating
outdating11810863outdating
outeating10814493outeating
outrating10916403outrating
patinating1339883patinating
patriating13510203patriating
pirating11314513pi_rating
pitting103618873pit__ting
radiating111112133radiating
retinting102215253retinting
rotating92614553rot_ating
seriating10916403seriating
sibilating1346973sibilating
sinuating1039683sinuating
sitting83519633sit__ting
stating83725163_st_ating
stilting93312403_stilting
stinting93415743_stinting
striating10914193striating
tilting83417103__tilting
tinting84620603__tinting
titillating1243713titillating
tittivating1552593tittivating
ultimating1386803ultimating
uptilting1234713uptilting
urticating1347353urticating
vacating14310363v_acating
validating1545843validating
valuating1338653valuating
vatting113614853vat__ting
ventilating1546343ventilating
vesicating1646903vesicating
vetting114216563vet__ting
vialing113614163v__ialing
victualing1643403victualing
vilifying1944493vilifying
vindicating1844643vindicating
vinifying1944713vinifying
visaing11279333vi_sa_ing
visioning1347063visioning
vitamin1237423vit_amin_
vitamine1347373vit_amine
vitamins1347083vit_amins
vitiate103412953vitiat__e
vitiated12289223vitiat_ed
vitiates112311433vitiat_es
vitiator1147043vitiat_or
vitiators1246923vitiators
vitrain1038943vitra_in_
vitrains1138283vitra_ins
vitrifying2044173vitrifying
vitrioling1443583vitrioling
vittling1236143vit_tling
vivifying2243843vivifying
vomiting1437733vomi_ting
witting113417063wit__ting

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.436409841.7
2DLD Change Limit1486411236.61022487.3
3Display Results1231230.0631952.4
 (SQL Overall)1786911237.10925135.9
 
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.