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

406 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
objets1512532(None) 
objects18123691objects
objet141213141objet_
abets75621672ab_ets
beets76131442_beets
bets67051442_b_ets
blets75324942_blets
ebbets10376832ebbets
gobbets12327642gobbets
goblets103210182goblets
jets115834102__jets
obes66036832ob_e_s
obeys107010642ob_eys
obits74617552ob_its
object17135802object
oboes75717712oboe_s
obsess845942obsess
obtest81213012obtest
obtests9136232obtests
obverts1235402obverts
octets839402octets
onsets64013542onsets
owlets93110392owlets
abates85825033abates
abbes96723523abbe_s
abbess10509773abbess
abbeys13538423abbeys
abbots1039283abbots
abet610547943ab_et_
abject17137703abject
ables75935543able_s
ablest84721833ablest
aborts84916183aborts
absents93510723absents
abuts75417073ab_uts
abyes105518533abye_s
aglets73915683aglets
armets84918353armets
assets65617663assets
bahts105617803_bahts
baits76630583_baits
basts75936933_basts
bates75846343_bates
bats66962333_b_ats
batts76727563_batts
beats76042243_beats
beds75937783_b_eds
beefs105618563_beefs
beeps95320973_beeps
beers75628393_beers
bees65453383_b_ees
beet66457543_beet_
begets96215523begets
begs75733833_b_egs
bels66142493_b_els
belts75931163_belts
bens65945703_b_ens
bents76033693_bents
berets85822523berets
bes56557433_b_e_s
besets85718803besets
best66355323_b_est
bests75932613_bests
bet58376673_b_et_
beta66234133_b_eta
betas75528763_b_etas
beth96629233_b_eth
beths105519223_b_eths
beys913829553_b_eys
bhuts105812953_bhuts
bidets95215533bidets
biers76225223_biers
bints76130183_bints
bites75641173_bites
bits66148163_b_its
bitts75022593_bitts
blats75132503_blats
bleats85518613_bleats
blebs96416153_blebs
bless75917813_bless
blest76431723_blest
blet66247673_blet_
blots75626173_blots
bluets87215493bluets
boarts84716873boarts
boasts85017923boasts
boats75635153_boats
bobbers103614283bobbers
bobcats1335993bobcats
bodes84935103bode_s
bogeys124510913bogeys
boheas114013213boheas
boites84322703boites
boles75448603bole_s
bolete8519613bolete
boletes9316063boletes
boleti8413403boleti
boletus948643boletus
bolts76232113_bolts
bomblets1436023bomblets
boners84825433boners
bones76446533bone_s
bonnets94812803bonnets
boosts86115013boosts
boots75837973_boots
boreas85421733boreas
borers85122683borers
bores76448253bore_s
borts76735453_borts
boskets13409473boskets
botels84815803botels
bots66453953_b_ots
botts75224863_botts
bouts75131313_bouts
bowels114315593bowels
bowers115523703bowers
boxers155013483boxers
boxes145625073boxe_s
brats75336013_brats
brees75632553_brees
brens75823363_brens
brents84717273_brents
brews105617073_brews
brits76433083_brits
bruts75922953_bruts
bunts75729803_bunts
burets84321263burets
busts75227693_busts
butes714535873_butes
buts67247693_b_uts
butts75824253_butts
byes95230533_bye_s
bytes105217493_bytes
cablets114216343cablets
cadets96316513cadets
carets85330773carets
civets115212543civets
cobalts1139203cobalts
cobbers134114753cobbers
cobles104622883coble_s
cobnuts1135353cobnuts
cobwebs1631933cobwebs
collets93517903collets
comets105823583comets
coquets18399893coquets
cornets94820573cornets
corsets94819803corsets
corvets124715023corvets
cosets85824403cosets
cossets95014283cossets
covets114819643covets
cruets85314953cruets
culets85518513culets
curets84922343curets
deets65330243_deets
dejects17389223dejects
diets66026643_diets
dobbers123513253dobbers
dobies94422093dobie_s
dockets144412243dockets
doublets11257363doublets
duets65323883_duets
duvets1039223duvets
ebbet93517293ebbet_
egrets72712243egrets
ejects15409953_ejects
emmets10349153emmets
facets116316653facets
fanjets1734803fanjets
fets75345943__fets
filets94718953filets
fleets96915063fleets
forgets113813793forgets
frets85523403_frets
fumets114311813fumets
genets75716663genets
gets55442483__gets
gibbets12417723gibbets
giblets103210423giblets
gleets75315053gleets
gobbet114214443gobbet_
gobies95418063gobie_s
goblet93219483goblet_
goboes95914443goboe_s
godets8410933godets
goglets9379783goglets
gorgets94711783gorgets
greets75117423greets
haets86525123_haets
hajes155420943haje_s
hets75547203__hets
hobbers143512343hobbers
hobbits14317553hobbits
hoboes114717443hoboe_s
hoggets12498323hoggets
hornets104113553hornets
howlets13329223howlets
injects16257453injects
inlets63915573inlets
insets64016133insets
islets64513083islets
jees115938543__jees
jess116022033__jess
jest116738503__jest
jests125922453__jests
jet106754823__jet_
jete115927253__jete
jetes124922843__jetes
jews145822083__jews
jobbers182911133jobbers
jobless16237563jobless
jots116336143__jots
juts115930163__juts
keets95123483_keets
khets124913433_khets
kopjes1935363kopje_s
labrets939363labrets
leets54927123_leets
lets47147943__lets
lobbers113713943lobbers
lobes75331003lob_e_s
lockets134612203lockets
loggets9378913loggets
lunets66914763lunets
meets74224613_meets
mobbers133610923mobbers
moppets13307163moppets
motets84216193motets
nets45941533__nets
nobles83319723noble_s
noblest93613563noblest
nonets64118703nonets
oases55330983oase_s
oasts56529183o_asts
oaters65029793oaters
oats46554213o__ats
oaves84925613oave_s
obas65730933ob__as
obe56638643ob_e__
obeah1038993ob_eah
obeahs1135863obeahs
obeli73711933ob_eli
obelus8348403obelus
obento837893obento
obentos936703obentos
obese75212423ob_ese
obey96521303ob_e_y
obeyers1234813obeyers
obias76116863ob_ias
obis66226843ob__is
obit66837083ob_it_
objected2043493objected
objector1943803objector
objectors2044053objectors
oblast8613663oblast
oblasts947303oblasts
oblate82214743oblate
oblates91913243oblates
oboe66822943oboe__
oboist8312683oboist
oboists937903oboists
oboles83815833oboles
obols73715863ob_ols
obolus8378813obolus
obtect10129633obtect
obverse1234753obverse
obvert11412993obvert
ochers113915303ochers
ockers123813903ockers
octet7324063octet_
oddest81710863oddest
odes57243243o_de_s
odists749853odists
oes35866193o__e_s
offers12349963offers
offsets1333503offsets
oftest91212003oftest
ogees65119143o_gees
oglers74313183oglers
ogles65223183ogle_s
ogres65818633ogre_s
ogress7529503ogress
oilers64721193oilers
okehs12477463o_kehs
okes84936343o_ke_s
oldest72114093oldest
oleos55419683o_leos
oles46453473o_le_s
ombers104214403ombers
ombres103911143ombre_s
omelets938333omelets
omens75618963o_mens
omers76923193o_mers
omits75018263o_mits
oncet74626543oncet_
ones46146533o_ne_s
onset54730173onset_
oots46446443o__ots
oozes145418713ooze_s
opens76118553o_pens
opes65942613o_pe_s
opts68124743o__pts
orates64328613orates
orbiest9312413orbiest
orbits84211443orbits
orbless937493orbless
orders74315993orders
ores46056683o_re_s
orgeats838353orgeats
oriels64914623oriels
orients7311583orients
orles55326213orle_s
ormers84316143ormers
orts46538333o__rts
oses46641513o_se_s
osiers63412793osiers
others93918003others
otters64021513otters
oughts104710183oughts
ousels64815273ousels
ousts55225703o_usts
outeats72215703outeats
outers64230173outers
outjuts1476493outjuts
outlets73616363outlets
outs45746963o__uts
outsets73514923outsets
ouzels15408703ouzels
ovens86217453o_vens
overs85224793o_vers
owes75137103o_we_s
owlet83324463owlet_
owners94210703owners
oxes116530723o_xe_s
oxters134813273oxters
oyers87620883o_yers
oyes74940133o_ye_s
palets85122313palets
pets66248333__pets
pipets105714773pipets
pockets154612253pockets
poets76024443_poets
poppets10338853poppets
possets94212773possets
projets1639163projets
propjets1935493propjets
quiets154014373quiets
rabbets11279423rabbets
rajes125022783raje_s
ramets83517393ramets
ramjets1635163ramjets
rejects163910693rejects
relets64025673relets
reobjects2062003reobjects
resets65427613resets
rets45352563__rets
revets94022173revets
rewets94617213rewets
riblets93412553riblets
rivets94417113rivets
robbers112814163robbers
robes75133303rob_e_s
robles85321693roble_s
robots8313153rob_ots
rochets124213473rochets
rockets134615363rockets
roquets16398943roquets
rosets65819953rosets
sets45549503__sets
sheets93918503sheets
skeets104513253skeets
sleets64318873sleets
sobbers114114263sobbers
sobers85218863sob_ers
sockets134012983sockets
sonnets74211993sonnets
sorbets93012513sorbets
soviets1087293soviets
stets55423913_stets
subjects19226533subjects
sublets92616703sublets
subnets92512083subnets
subsets92813103subsets
suets55126103_suets
sweets94214433sweets
tablets94714383tablets
tajes124920693taje_s
tenets65518953tenets
tets45847463__tets
tobies84521023tobie_s
toilets74112913toilets
tonlets73212503tonlets
toquets16367863toquets
trets55928023_trets
trijets14308263trijets
tweets94210103tweets
ubiety1135913ubiety
unsets64116163unsets
upsets8409683upsets
valets93715623valets
vets76835093__vets
weets85427723_weets
wets75940293__wets
whets115019613_whets
worsets105512843worsets
zibets1737743zibets

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127164064.95322757.1
3Display Results4064060.1263222.2
 (SQL Overall)1786914065.45232775.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.