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

139 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
ovarian103764(None) 
ovarial1037611ovarial
covariant1447862covariant
ocarina948032ocarina
ovaries10312652ovaries
ovation101510022ovation
overman12311462overman
overran10311662overran
parian83223962_parian
rosarian847592rosarian
varia85824202_varia_
variant10316802_variant
varias95019902_varias
acaridan1165233acaridan
agrarian948253agrarian
apian75018333__apian
apiarian1048323apiarian
aquarian1747013aquarian
aria46245423__aria_
arias55438023__arias
avarice1238033avarice
avian84616053__avian
banian8315383_banian
barman103519703_barman
calvarian1446863calvarian
carina84325333_carina
carman103920743_carman
cesarian1048183cesarian
clarion9311663clarion
covariance1753943covariance
covariate1446213covariate
covaried1448003covaried
covaries13413253covaries
cyprian1445343cyprian
czarina1845953czarina
durian7312003_durian
evasion1036753evasion
farina94618233_farina
filarian1148313filarian
gharial1137343gharial
guardian1045113guardian
hariana10310243_hariana
harijan1735783_harijan
invariant1266813invariant
jarina134014063_jarina
kalian10312163_kalian
lariat6629043_lariat
lunarian847293lunarian
magian9312833_magian
malarian10311563malarian
maria75032883_maria_
marina84623413_marina
martian93514683_martian
narial6317953_narial
notarial8410753notarial
novation111710013novation
oaring74225303o_aring
oarsman937733o_arsman
ocarinas1036733ocarinas
oration71617713oration
organ6915393o__rgan
origan7310693o__rigan
ouabain944943ouabain
outran63218893outr_an
ovality1377593ovality
ovariole1144923ovariole
ovaritis1145953ovaritis
ovary1149113ovar__y
ovations11149263ovations
overeat102620323overeat
overfar13227943overfar
overfat132712283overfat
overhand15229963overhand
overhang15248863overhang
overing111918053overing
overlain112112443overlain
overland122312003overland
overlap12239833overlap
overlax17238413overlax
overlay132410833overlay
overmans13310313overmans
overmany1647143overmany
overmen12311803overmen
overpay15228263overpay
overplan13258943overplan
overrank1548113overrank
overrun1038023overrun
oversad11259963oversad
oversaw13268163oversaw
overtax17257733overtax
pariah114320583_pariah
parians93519733_parians
partan83820563_partan
quartan1636423quartan
radian74117273_radian
riparian1047523riparian
rosaria749253rosaria_
rosarians945793rosarians
saran53730303_sar_an
sarin55239253_sari_n
saurian739913saurian
savarin10310003savari_n
sharia93116733sharia_
shariah132210533shariah
sharias102516003sharias
solaria7312493solaria_
sonarman1045563sonarman
sovran937153sov_r_an
spartan948333spartan
svaraj1634963svar_aj
tarpan82814293_tarpan
tartan64217513_tartan
tarzan152910753_tarzan
therian10311293therian
tovarich1643453tovarich
tovarish1445123tovarish
tsarina736653tsarina
tzarina1635053tzarina
vagina102710933_vagina
vain75233003_va_i_n
valerian1147123_valerian
valiant10314623_valiant
vanman1139793_vanman
vara75530883_var_a_
varas86028193_var_as
variance1397413_variance
variants1139203_variants
variate101316433_variate
varied104817863_varied
varier94619353_varier
varies94330873_varies
varix154313513_vari_x
varna84516173_varna_
varnas94212823_varnas
vermian12329713_vermian
virion9310683_virion
vivaria1346983vivaria_
zoaria1548383zoaria_
zoarial1646923zoarial

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 Filter1786911340270.390458182.1
2DLD Change Limit1340271397.36018210.2
3Display Results1391390.0632206.3
 (SQL Overall)1786911397.81322871.0
 
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.