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

217 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
ruinated93952(None) 
ruinate7312831ruinate_
ruinates8311881ruinates
ruminated1258661ruminated
urinated9311611urinated
lunated8310822lu_nated
quinate16511572quinate_
resinated10413282resinated
ruined74813322ruin__ed
ruminate10511472ruminate_
ruminates11410192ruminates
supinated1237882supinated
urinate7315362urinate_
urinates8314132urinates
acuminated1545873acuminated
agitated1038413agitated
alienated1047743alienated
animated111612373animated
arointed939003aroin_ted
aurated83817793au_rated
aviated11310263avi_ated
binate8419773_binate_
brominated1546403brominated
bruited104110353brui__ted
bunted95219183bu_n_ted
carinated123414263carinated
crenated113013913crenated
criminated1546823criminated
culminated1546103culminated
cuneated11310103cuneated
curated104717583cu_rated
cuspated1335913cuspated
dilated93115823_dilated
dinted84419843_din_ted
dominated1339883dominated
donated93513863_donated
dunted84718503du_n_ted
echinated1546483echinated
emanated1139163emanated
epilated11310753epilated
eructated1245643eructated
fainted114211723fain_ted
feinted11379623fein_ted
fixated1835533_fixated
flinted114411893flin_ted
fruited11389093frui__ted
fulminated1645023fulminated
fumigated1644723fumigated
furcated1437593furcated
furnaced1443513furnaced
geminated1338553geminated
germinated1446563germinated
glinted9399373glin_ted
grunted9339283gru_n_ted
guttated10266873guttated
hinted104318323_hin_ted
hunted104417013hu_n_ted
imitated1138263imitated
iodinated1146943iodinated
irrigated1176313irrigated
irritated1076133irritated
jointed15378503join_ted
jubilated1944933jubilated
laminated122610283laminated
lanated8313203_lanated
ligated92414143_ligated
lineated9711063_lineated
linted74021823_lin_ted
lunate6316043lu_nate_
lunted74517523lu_n_ted
luxated1535713lu_xated
marginated14187343marginated
marinated122513173marinated
minted94220583_min_ted
minuted10329503_minuted
muriated1139793muriated
muricated1448243muricated
mutated102712253mu_tated
mutilated1239453mutilated
nidated939863_nidated
nominated1239283nominated
nutated83113423nu_tated
opiated1039483opi_ated
ordinate9310253ordinate_
ordinates1049003ordinates
originated1244813originated
outdated1012513193outdated
outrated92219313outrated
oxidated1745033oxidated
ozonated1864593ozonated
paginated13309463paginated
painted104214633pain_ted
patinated123911413patinated
pennated11299543pennated
phonated1447893phonated
pinnated11338553pinnated
pirated102515613_pirated
plicated13310643plicated
pointed103813983poin_ted
printed104016373prin_ted
pronated11414053pronated
pulsated1136853pulsated
punted94618713pu_n_ted
pupated12319353pu_pated
quanted1738963quan_ted
quieted17309723qui_eted
quilted17319313qui_lted
quinsied1845043quinsied
quinte153414523quin_te_
quintes164114713quin_tes
quintet163914453quin_tet
quirted17369213qui_rted
quitted17339893qui_tted
radiated102512593radiated
radicated13410123radicated
rained75024603rain__ed
rainwater1244573rainwater
ranted74324703r_an_ted
rated65441383r___ated
rebated103619703r_ebated
recanted112513513recanted
recoated113416783recoated
recrated112918603recrated
redated93120923r_edated
reenacted1236853reenacted
reflated123514293reflated
regrated102816333regrated
reheated122415003reheated
reignited1145683reignited
reimaged1246173reimaged
reincited1246853reincited
reined74425523rein__ed
reinflated14146473reinflated
reinked1239793rein_ked
reinstated1147283reinstated
reinter73116843rein_ter
reinvaded1444073reinvaded
reinvited1386193reinvited
related83327573r_elated
remated103522473r_emated
reminted113615083remin_ted
renamed103114523r_enamed
rented74426593r_en_ted
repeated113117443repeated
replated112817523replated
reseated93220263reseated
resinate8316773resinate_
resinates9314763resinates
reslated93517523reslated
resonated10510613resonated
restated93120183restated
retinted94414363retin_ted
reunited939713reunited
rifted104115313r_i_fted
righted122912143r_ighted
rinded84418983r_in_ded
ringed84623843r_in_ged
rinsed75016353r_in_sed
rioted73416373r_i_oted
rivaled1138933r_ivaled
riveted11258573r_iveted
rotated82715293r_otated
rubricated1545043rubricated
rugate75813813ru_gate_
ruinable1039263ruinable
ruinating1039593ruinating
ruination9311273ruination
ruiner64013643ruin__er
rumbaed12287493rumba_ed
ruminator1166813ruminator
rummaged1443273rummaged
runcinate1146473runcinate_
runkled12399013ru_nkled
rusted75020923ru__sted
rusticated1346993rusticated
rutted74518403ru__tted
sainted84114243sain_ted
sinuated938413_sinuated
spicated13309903spicated
spinate93114813spinate_
squinted1847063squin_ted
stinted82914193stin_ted
sublated11311503sublated
suited74019423sui__ted
sulcated11310373sulcated
sulfated1238833sulfated
summated13298833summated
supinate10310313supinate_
supinates1139553supinates
surnamed1135113surnamed
tainted83512423tain_ted
terminated1348163terminated
tincted1037273_tincted
tinted74419533_tin_ted
truanted935373truan_ted
truncated1244583truncated
tunicated12257493tunicated
turbinated1344413turbinated
unacted10312733_u_nacted
unaged83916423_u_naged
unawed103914903_u_nawed
unaxed144113093_u_naxed
unbated103317733_unbated
undated93118463_undated
ungated92717213_ungated
united74421543_u_nited
unmated103317023_unmated
unnamed102410273_unnamed
unnoted8311363_unnoted
unrated82621553_unrated
unsated83419933_unsated
updated11369423_updated
uprated103213323_uprated
urinator847843urinator
urticated1247693urticated
vaginated14328153vaginated
zonated173310533_zonated

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 Filter1786911461620.423422437.4
2DLD Change Limit1461622177.47019566.5
3Display Results2172170.0932333.3
 (SQL Overall)1786912177.98622375.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.