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

324 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
ophites1231010(None) 
ophite11410561ophite_
aphides134711202aphides
aplites9314932aplites
gothites1246012gothites
hoplites13310542hoplites
oolites72817842oolites
oophytes1646032oophytes
ophitic1439212ophitic
opiates9312142opiates
opines84820702op_ines
optimes1148472optimes
phizes20389132_phizes
podites103014732podites
sophies12314622sophi_es
sopites93817172sop_ites
spites84127332sp_ites
sprites94220332sprites
whites123919882_whites
achiotes1339003achiotes
albites9313203albites
apatites10311293apatites
aphanites1448273aphanites
apheses12610703apheses
aphids125110843aphi_ds
aphis105917133aphi__s
apices104916263ap_ices
aplite8316393aplite_
apsides103911303apsides
ascites9312603ascites
augites8312183augites
axites134913833_axites
barites94322333barites
bites75641173__bites
blites84721213_blites
bobwhites1942193bobwhites
boehmites1663023boehmites
boites84322703_boites
bornites10310983bornites
bothies12414783bothi_es
cerites94823433cerites
chides124620473_chides
chiles115425303_chiles
chimes134922573_chimes
chines115029173_chines
chits105424573_chit_s
chives144317593_chives
chutes114615773_chutes
cites74435593__cites
coesites101313093coesites
copies104130303cop_i_es
copihues1543993copihues
coppices1638243coppices
cordites11314623cordites
cowhides1736013cowhides
cowrites133011593cowrites
cuprites1259023cuprites
curites93919863curites
dacites101114593dacites
dites66339153__dites
dunites8313593dunites
elites66027123_elites
endites83717063endites
enophiles1448433enophiles
ephebes1436153ephebes
equites162212493equites
evites94916473_evites
excites16310633excites
finites10315923finites
flites95122443_flites
fomites123613203fomites
frites94922483_frites
gahnites1235703gahnites
geophytes1845403geophytes
gites65630183__gites
gobshites1542933gobshites
goethites1344253goethites
gothite1146403gothite_
graphites1546823graphites
gunites8313123gunites
halites103221193halites
haplites1339993haplites
hates86742573__hates
hides95129423__hides
hies74842833__hi_es
hikes125426983__hikes
hires86134343__hires
hits75545133__hit_s
hives116925513__hives
hoplite12311073hoplite_
ichnites1345743ichnites
ignites81310583ignites
illites72415013illites
incites93218483incites
indites83618983indites
invites103915813invites
iolites73819483iolites
isophotes1466463isophotes
kites95432543__kites
koppies153210013koppi_es
lenites7818443lenites
limites92915453limites
lucites9311863lucites
mephitis1546113mephitis
mites75141803__mites
morphines1648233morphines
neophytes1745943neophytes
nephrites1446503nephrites
nites55736343__nites
nonwhites1545393nonwhites
norites74018803norites
obits74617553o_bit_s
oblates91913243oblates
obliges1037143obliges
obviates1345153obviates
ochres113510833och_res
oddities1046603oddities
offices1536243offices
ogives10367913o_gives
ohias84415573o_hi_as
oldies7314423oldi_es
oleates7417833oleates
oleines7313393oleines
olives94313953o_lives
omits75018263o_mit_s
oocytes1246063oocytes
oolite63319603oolite_
ooliths10268323ooliths
oophyte1545633oophyte_
opacities1347943opacities
opalines10311423opalines
opaques1833643opaques
operates10515413operates
opes65942613op___es
ophiolites1544193ophiolites
opiate8513463opiate_
opiated1039483opiated
opine77422463op_ine_
opined95113853op_ined
opiums10307073op_iums
oppilates1345453oppilates
opposes1149243opposes
opposites1346143opposites
opsins8411713opsi_ns
opted84914273op__ted
optics102810183opti_cs
optime1079353optime_
options93810603options
opts68124743op__t_s
opuses84012243op_uses
orates64328613o_rates
orbited1037733orbited
orbiter937853orbiter
orbiters1036593orbiters
orbits84211443orbit_s
orchises1338773orchises
orchitis1346423orchitis
ordines83014903ordines
oreides8312023oreides
orgies72316093orgi_es
ornithes1136423ornithes
oroides8311973oroides
orphisms1545993orphisms
orpines94414793orpines
orrices9129363orrices
orrises71312233orrises
oscines9310363oscines
otitis63612343o_titis
ouphes113614633ouph__es
outhits102213503outhit_s
ovines94614343o_vines
oxides14109693o_xides
oximes15107423o_ximes
oxyphiles2442523oxyphiles
pastes85233913_pastes
pates76047893_p_ates
peises84125043_peises
pelites93821993pelites
petites93820203petites
phages125213513_phages
phases114618403_phases
phials1158873_phials
philter12108213_philter
philters1398173_philters
philtres1396513_philtres
phis95724903_phi__s
phones114121213_phones
phosphites2087043phosphites
photos113316643_photos
phots105418503_phot_s
phuts104613503_phut_s
physes14399783_physes
pies66949603_p_i_es
pikes115031033_p_ikes
piles74742613_p_iles
pines76048863_p_ines
pinites9319533pinites
pipes96030143_p_ipes
pistes85325633_pistes
pitas77427673_p_itas
piths105817543_p_iths
pities83828083_p_ities
pits66348743_p_it_s
pixes144323173_p_ixes
plates85432243_plates
plies74526513_pli_es
podite93315353podite_
pogies94123543pogi_es
pointes93216753pointes
poises84226543_poises
pokies125921333poki_es
polices113118053polices
polies84034583poli_es
polite83625073polite_
politer92417073politer
politest10312943politest
polities102722343polities
ponies84833463poni_es
pontes83627853_pontes
poplitei1245483poplitei
popliteus1353073popliteus
poppies102816203poppi_es
popsies112816463popsi_es
posies84431433posi_es
posited10511493posited
posits85718713posit_s
posties93128813posties
potties93723543potties
prates84633163_prates
prices104524543_prices
prides94324183_prides
pries74339533_pri_es
primes104225263_primes
prises84133173_prises
prizes173819813_prizes
psephites1643843psephites
pyrites12812203pyrites
raphides14188393raphides
ratites74920683ratites
recites93524583recites
rehires105016113rehires
resites74027793resites
rites54442553__rites
samites93118713samites
shies86136553_shi_es
shines95028913_shines
shires95225573_shires
shits84731173_shit_s
shives124921413_shives
shotes95321913_shotes
shutes93518223_shutes
sites56045433__sites
skites104418043_skites
smites83921923_smites
somites94219123somites
sophisms1546653sophisms
sophists1347293sophists
sopite84917713sop_ite_
sopited104211063sop_ited
sorites73825243sorites
spaits85017473spait_s
spates85028173sp_ates
speises93813933speises
sphenes123013163sphenes
spheres123114353spheres
sphinges14267483sphinges
sphinxes20334403sphinxes
spices104326033sp_ices
spies76037623sp_i_es
spikes124520713sp_ikes
spiles84227913sp_iles
spines85132033sp_ines
spires84628113sp_ires
spite75430663sp_ite_
spited94820443sp_ited
spits74429553sp_it_s
spitzes1849183sp_itzes
splices113914383splices
splines94718893splines
splits85416413split_s
sprite84421773sprite_
sprits85122533sprit_s
spritzes1946943spritzes
suites63727403_suites
sulphites1445683sulphites
taxites1449673taxites
tephrites1446313tephrites
tophes115218423toph__es
toplines102412563toplines
topsides1137203topsides
trophies13413673trophi_es
unites65024853_unites
updates10329793updates
updives1334713updives
uphills1295233uphills
uphroes1236303uphroes
uppiles11208263uppiles
uprates93814863uprates
uprises92012733uprises
upsides10319633upsides
upsizes18297163upsizes
uptimes1177553uptimes
vahines133410523vahines
velites103417303velites
verites103822263verites
wahines133111173wahines
whiles124418013_whiles
whines125120103_whines
white114920303_white_
whited134814083_whited
whiten124111923_whiten
whitens13428733_whitens
whiter124316393_whiter
whitest133710113_whitest
whitey154911883_whitey
whiteys16396153_whiteys
whities133113253_whities
whits115923823_whit_s
wites85536963__wites
writes94420333_writes
yperites13310153yperites
zoisites1744973zoisites
zoophiles2356523zoophiles
zoophytes2644963zoophytes

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.406440125.6
2DLD Change Limit1340273246.86019537.5
3Display Results3243240.1063056.6
 (SQL Overall)1786913247.37224239.1
 
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.