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

213 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
obtests913623(None) 
obtest81213011obtest_
attests7278812attests
bests75932612_b_ests
contests103413382contests
detests83711742detests
latests73910312latests
mostests1036832mostests
objects18123692objects
objets15125322obje_ts
oblasts947302oblasts
oboists937902oboists
obsess845942obses_s
obtect10129632obtect_
obtested1135452obtested
obverts1235402obverts
octets839402octe_ts
oftest91212002oftest_
outeats72215702outeats
outsets73514922outsets
retests73813852retests
subtests1037532subtests
tests56530192__tests
abbess10509783abbes_s
abets75621683ab_e_ts
ableists1036563ableists
ablest84721833ablest_
absents93510733absents
aptest82917513aptest_
arrests73312693arrests
artists74215603artists
attest62618613attest_
autists73814853autists
basts75936933_b_asts
beasts84519723_beasts
beats76042253_b_eats
beets76131443_b_eets
behests1235953behests
belts75931163_b_elts
bents76033693_b_ents
beses75830723_b_eses
besets85718803_b_esets
besots86415453_b_esots
best66355323_b_est_
bets67051443_b_e_ts
blasts85116773_blasts
bleats85518623_bleats
bless75917813_bles_s
blest76431723_blest_
blets75324943_ble_ts
boasts85017923_boasts
bonesets1036843bonesets
boosts86115013_boosts
botels84815803bote_ls
botts75224863bot__ts
breasts939713_breasts
brents84717283_brents
bursts85116243_bursts
busts75227693_b_usts
chests114916263_chests
coattests1143463coattests
congests113510383congests
contents104018213contents
contest93523233contest_
contexts17378653contexts
crests85218703_crests
cutest85820143cutest_
detects104011093detects
detents83615153detents
detest74122843detest_
devests114410473devests
digests93610613digests
divests114510933divests
ebbets10376843ebbe_ts
egests74411253_egests
extents142610173extents
fests85828043__fests
footrests12244503footrests
forests104114953forests
gabfests1442383gabfests
geests75912163_geests
gests66028813__gests
gobbets12327643gobbe_ts
goblets103210183goble_ts
guests74311203_guests
hests85829933__hests
hostess103210243hostes_s
hottest10411383hottest_
incests92711383incests
infests10279793infests
ingests83210983ingests
intents72115703intents
invests10319683invests
jests125922453__jests
jobless16237563jobles_s
latents75214313latents
latest63822703latest_
lutists73810273lutists
molests93311563molests
mostest9314793mostest_
motets84216193mote_ts
mutest84218053mutest_
nests55728003__nests
noblest93613563noblest_
oasts56529183o__asts
oaters65029793oate_rs
obeahs1135863ob_eahs
obelus8348403ob_elus
obento837893ob_ento
obentos936713ob_entos
obes66036833ob_e__s
obese75212423ob_es_e
obesity1275653ob_esity
obeys107010643ob_e_ys
obiisms1135673obiisms
obits74617553ob__its
object17135803object_
objet141213143obje_t_
oblast8613663oblast_
oblasti945953oblasti
oboes75717713oboe__s
oboist8312683oboist_
obsesses1036223obsesses
obtains939163obtains
obtected1344553obtected
obtesting1245883obtesting
obtunds1033763obtunds
obtuse8147483obtus_e
obtuser9134453obtuser
obtusest1044573obtusest
obtusity1343693obtusity
obverses1335803obverses
obvert11412993obvert_
octants9128733octants
octet7324063octe_t_
octette946423octette
octettes1045533octettes
oddest81710863oddest_
odists749853o_dists
offsets1333503offsets
ogress7529503ogres_s
oldest72114093oldest_
onsets64013543onse_ts
oocysts1243923oocysts
orbiest9312413orbiest_
orbless937493orbles_s
orgeats838353orgeats
orients7311583orients
osteitis847023osteitis
osteoses839033osteoses
osteosis846743osteosis
ostoses71213553ostoses
ostosis71310123ostosis
otters64021513otte_rs
ousts55225703o__usts
outacts9310213outacts
outasks1138173outasks
outcasts10108683outcasts
outeat62824533outeat_
outers64230173oute_rs
outfasts11117233outfasts
outfeasts12114333outfeasts
outfits102210833outfits
outhits102213503outhits
outjuts1476493outjuts
outlasts8108713outlasts
outlets73616363outlets
outposts1037253outposts
outputs988493outputs
outsees72616433outsees
outserts8309803outserts
outset64027453outset_
outsits73215253outsits
outwits103110863outwits
ovotestes1242533ovotestes
ovotestis1251753ovotestis
owlets93110393owle_ts
oxters134813273oxte_rs
patents94815203patents
pests75933273__pests
poetess938933poetes_s
portents103512823portents
posttests1144973posttests
prests84021263_prests
pretests10310013pretests
priests93810863priests
protests10310493protests
quests153310353_quests
reests64618893_reests
renests74014213renests
rests54935873__rests
retest64028453retest_
revests104413743revests
softest10310603softest_
stents65019453_stents
stets55423913_ste_ts
subtest9513963subtest_
subtexts1744903subtexts
teats55636813__teats
tents56434213__tents
test48651623__test_
testa54822043__testa
testes65125823__testes
testis64916713__testis
testy85419063__testy
tets45847463__te_ts
texts125515043__texts
unrests7229463unrests
urtexts1433143urtexts
vests85325983__vests
wests85727003__wests
wrests95313083_wrests
zests145419743__zests

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 Limit1340272136.50020619.5
3Display Results2132130.0762802.6
 (SQL Overall)1786912136.96625651.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.