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

170 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
osetras73733(None) 
osetra667421osetra_
ossetras844091ossetras
oestrus7169582oestrus
olestras846582olestras
operas8312452ope_ras
ossetra744072ossetra_
sutras64818592_sutras
tetras63017622_tetras
ashtray13805553ashtray
ashtrays14534203ashtrays
asterias8317013asterias
asters65631603aster_s
astral66919283as_tral
astrals75515243as_trals
astray95615543as_tray
betas75528763_bet_as
betray111511443_betray
betrays12127823_betrays
bettas84913923_bettas
cestas85018543cest_as
cesuras958693cesuras
contras93015623contras
cosets85824403coset__s
costars94218013cos_tars
costers94128333coster_s
dosers75723633dose_r_s
droseras935883drose_ras
eras45441503__e_ras
esterase849483esterase
esters64627733ester_s
estral64716513es_tral
estray95713333es_tray
estrays10529403es_trays
estrus61912113es_trus
etas46432273__et_as
etnas54713933__etnas
extras13310223_extras
eyras84715923__eyras
fetas85624403_fet_as
fosters104220103foster_s
getas65421483_get_as
godetias1045343godetias
hosers95223973hose_r_s
hostas94515833hos_t_as
losers65123583lose_r_s
mantras93815863mantras
metres85121563_metres
metros84217803_metros
monsteras11318243monsteras
mousetrap1352423mousetrap
mousetraps1452123mousetraps
mozettas1993553mozettas
oaters65029793oater_s
obelias9279033obelias
oestrin7312243oestrin
oestrins8312673oestrins
oestrous869923oestrous
oestrum9177783oestrum
oestrums10156473oestrums
okras94410973o__kras
olestra746173olestra_
omegas936983ome_gas
omers76923193ome_r_s
onsets64013543onset__s
opera7313573ope_ra_
oses46641513ose___s
osiers63412793osier_s
osteal6312963os_teal
osteomas1045333osteomas
ostia52315583os_tia_
ostraca937823os_traca
ostraka1144833os_traka
ottars64112223o_ttars
otters64021513otter_s
ousters74122793ouster_s
outers64230173outer_s
outgas7313203o_utgas
outran63218893o_utran
overran10311663overran
overrash1436953overrash
overs85224793ove_r_s
overtask1535773overtask
overtax17257733overtax
oxters134813273oxter_s
oyers87620883oye_r_s
oysters103411693oyster_s
pesetas938753peset_as
pietas84516503piet_as
pleuras937413pleuras
posers84223973pose_r_s
poseurs9378303poseur_s
posterns102713723posterns
posters93928013poster_s
retral64419743_retral
retros63820193_retros
ristras7311563ristras
roseolas8107173roseolas
rosets65819953roset__s
rosettes8310343rosettes
rosters73727543roster_s
rostra6310933ros_tra_
rostral7311333ros_tral
sabras85116363_sabras
sataras7315063_sataras
satrap86212553_satrap
satraps95011643_satraps
sears54744913_sear_s
seas45755273_se__as
seers55136383_seer_s
selvas93812913_selvas
sennas64214233_sennas
senoras72714953_senoras
sepias83616103_sepias
sera46141393_se_ra_
serac75925203_se_rac
seracs84418573_se_racs
serai56830163_se_rai
serais64326133_se_rais
seral56336383_se_ral
seres55448893_se_res
serfs84922013_se_rfs
sers45746653_se_r_s
seta45637313_set_a_
setae56026223_set_ae
setal56430903_set_al
setons64620173_setons
setous64917373_setous
sets45549503_set__s
setts55124323_set_ts
setups83910463_setups
sewars94018633_sewars
sierras737863sierras
sirras63814863_sirras
sitars65417593_sitars
softas94410403soft_as
soras55041013_s_oras
stars55836573_s_tars
steres63929533_steres
sterns64616763_sterns
stoas55126023_s_toas
strap77925263_s_trap
straps87721783_s_traps
strass67117223_s_trass
straw813321293_s_traw
straws98718673_s_traws
stray88525573_s_tray
strays96417933_s_trays
suras55336333_s_uras
surras65919533_surras
sutra54217933_sutra_
suttas63813793_suttas
tantras73112093tantras
terras63516973_terras
tetra53417953_tetra_
tetrad73612053_tetrad
tetrads82910193_tetrads
tetris62816293_tetris
thetas93011573thet_as
tsetses785453tsetses
ultras6310193_ultras
urethras1174613urethras
users55817573use_r_s
vestas95916683vest_as
vestral104111013vestral
womeras1287603wome_ras
yantras10259003yantras
zebras1737853_zebras
zetas145018163_zet_as
zosters163015413zoster_s

Search took 7 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.403443402.0
2DLD Change Limit1340271706.20621596.4
3Display Results1701700.0602833.3
 (SQL Overall)1786911706.66926794.3
 
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.