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

327 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
diopters113769(None) 
diopter1038471diopter_
dioptres1146111dioptres
adopters1136692adopters
copters113621282_copters
diapers104713912diap_ers
diasters92913182diasters
diesters92513602diesters
dieters83216432di_eters
dilaters92513062dilaters
diluters9288112diluters
dimeters11411092dimeters
dioptre1055762diopt_re
dippers123615182di_ppers
diptera1037212di_ptera
disputers1236612disputers
dopers95522482d_op_ers
doters74423912d_o_ters
dotters83715972d_otters
droppers13318602droppers
rioters73615522rio_ters
aborters1038573aborters
adapters1136103adapters
adoptees1145123adoptees
adopter1036763adopter_
biometers1339173biometers
bisters93922613bi_sters
biters83925243bi__ters
bitters94920363bi_tters
bloaters103311023bloaters
blotters104110983blotters
boaters93419243_boaters
bolters94017803_bolters
boosters104013453boosters
boppers133911923_boppers
chapters154012133chapters
chiropters1744763chiropters
choppers174110463choppers
ciphers14379993ci_phers
citers85022983ci__ters
clouters10399803clouters
coaters93525793_coaters
cointers103616423cointers
colters93522443_colters
coopers114019483coop_ers
cooters94525733_cooters
copers104629843_cop_ers
copiers114215963_copiers
coppers133519753_coppers
copter109822013_copter_
costers94128343_costers
cotters94323453_cotters
couters93827303_couters
crofters13358913crofters
croppers143311483croppers
dabsters1137053dabsters
dampers123915693damp_ers
darters84017613d_arters
daters74827373d__aters
daunters9329853daunters
debaters113511923debaters
dempsters1435273dempsters
deporters1277793deporters
deposers11359243deposers
deters74724683d__eters
dewaters122910723dewaters
dialers83614303di_alers
diallers957773diallers
diameters1247603diameters
diaper94513113diap_er_
diapirs10347643diap_irs
diastems11226523diastems
diaster82813313diaster_
dibbers124013173di_bbers
dibblers13377583dibblers
dicers94720743di__cers
dickers144117663di_ckers
didappers1543173didappers
diddlers11359153diddlers
diester83013683diester_
dieter73516773di_eter_
diethers1257453diethers
differs14339973di_ffers
digesters11257883digesters
diggers104413393di_ggers
dikers114418793di__kers
dilater83515653dilater_
dilates83220663dilate_s
dilators93213203dilators
diluter8319663diluter_
dilutes82911973dilute_s
dilutors9306653dilutors
dimers94321093di__mers
dimeter10411893dimeter_
dimmers123811563di_mmers
dimples122813213dimple_s
diners75525953di__ners
dingers94321383di_ngers
dinners83915443di_nners
diodes83915783dio_de_s
dioptase1145513dioptase
dioptases1245903dioptases
dioptral1144683dioptral
dioptric1345633dioptric
dioptrics1444103dioptrics
diorites9313523diorite_s
dipnets10109033di_pnets
dipoles101013753dipole_s
dipper114017793di_pper_
dippier123111393dippier_
dipteral1147003di_pteral
dipteran1146203di_pteran
dipterans1245723di_pterans
dipteron1145593di_pteron
dipterous1256283di_pterous
disasters1039153disasters
disinters1039713disinters
disorders1146963disorders
dispels10310503disp_els
disperse111011353disp_erse
disposers1238373disposers
disputer1137973disputer_
disputes1139653dispute_s
disrupters1343933disrupters
distorters1147183distorters
ditchers143610363ditchers
dites66339153di__te_s
dithers114016153di_thers
divers105024963di__vers
diverters13227873diverters
dividers13257213dividers
diviners12308353diviners
divorcers1543693divorcers
dobbers123513253d_obbers
dockers143715003d_ockers
doctors1039993d_octors
dodders105511793d_odders
dodgers105213823d_odgers
doers65225713d_o__ers
doffers14359853d_offers
doggers104413433d_oggers
doodlers10338843doodlers
doomsters1236173doomsters
doozers17419293d_oozers
doper86128393d_op_er_
dopes84935043d_op_e_s
dopesters1237283d_opesters
dopier93515923d_opier_
dormers104313923d_ormers
dorpers104113173d_orpers
dorsers83516303d_orsers
dosers75723633d_o_sers
dossers84516233d_ossers
doter65428623d_o_ter_
dotes65836693d_o_te_s
dottels8327783d_ottels
dotter74419343d_otter_
doubters11257393doubters
dousers84817273d_ousers
dowers104523293d_o_wers
downers113912773d_owners
dowsers115013533d_owsers
dozers164815423d_o_zers
drafters12338533drafters
drapers105313353drap_ers
drifters12417913drifters
drippers13327943drippers
droners84114383dro_ners
droplets1136063droplets
dropper12329873dropper_
drovers115212643dro_vers
drowners12428273drowners
dumpers123412663dump_ers
dumpsters1453743dumpsters
dupers94615603d_up_ers
dusters84918363d_usters
elopers95112943elop_ers
emoters94712873emo_ters
fibsters13126413fibsters
fighters15269403fighters
filters103816553fi_lters
fitters104517753fi_tters
floaters112711513floaters
floppers15337463floppers
flouters11419273flouters
footers104618333_footers
fosters104220103_fosters
gippers123212083gi_ppers
gloaters9288863gloaters
goiters84014443_goiters
gophers1338983_gophers
gropers104813853grop_ers
grouters95910093grouters
hinters103719583hi_nters
hipsters13268793hipsters
hitters104717593hi_tters
hoisters113513493hoisters
hoopers123616493hoop_ers
hoopsters1445693hoopsters
hooters104520483_hooters
hopers114222973_hop_ers
hoppers143115143_hoppers
idolaters1045713idolaters
imputers1235823_imputers
inters64328053_i_nters
jilters144211963ji_lters
jitters144314473ji_tters
jointers15289323jointers
jolters143711993_jolters
jotters143413803_jotters
kiesters123310153kiesters
kilters113813603ki_lters
kippers153211433ki_ppers
kiters105218593ki__ters
knotters12276153knotters
lifters104313783li_fters
lighters123111393lighters
limiters10249333limiters
limpers113815223limp_ers
linters73822633li_nters
lippers113416443li_ppers
lispers94514323lisp_ers
listers74026533li_sters
liters65429883li__ters
litters73422573li_tters
lofters103912903_lofters
loiters74116613_loiters
loopers93914033loop_ers
looters74419163_looters
lopers84424143_lop_ers
loppers113014103_loppers
lotters73921063_lotters
milters93619093mi_lters
minsters103813923minsters
minters93822473mi_nters
misters93927513mi_sters
miters84328783mi__ters
molters93816973_molters
mooters93818623_mooters
mopers104220373_mop_ers
moppers133412463_moppers
nippers113012623ni_ppers
niters64624213ni__ters
noters64021003_no_ters
oaters65029793__oaters
otters64021513__otters
outers64230173__outers
oxters134813273__oxters
peoplers1237163peoplers
piasters102912813piasters
pioneers1035863pioneers
pipers104318663pi_p_ers
plotters104011553plotters
pointers103013723pointers
poofters1336923poofters
poppers103414863_poppers
porters93722703_porters
posters93928013_posters
potters94024343_potters
pouters94221873_pouters
powters124015663_powters
prompters1537553prompters
propers113619033prop_ers
quoters16369273quo_ters
righters122610713righters
rioter64817283rio_ter_
rippers114115033ri_ppers
ripplers12337113ripplers
ritters74020623ri_tters
riveters11228163riveters
roisters83615563roisters
roosters83514673roosters
rooters74522933_rooters
ropers84325903_rop_ers
rosters73727553_rosters
rotters74421393_rotters
routers74822873_routers
scepters1237793scepters
scooters103511033scooters
scoters93313813sco_ters
scouters103411323scouters
shooters112811583shooters
shoppers153010763shoppers
shouters113510623shouters
sifters103714793si_fters
sighters122510603sighters
simpers113014123simp_ers
sinters74024083si_nters
sippers113117753si_ppers
sisters73721593si_sters
sitters74221553si_tters
slopers94213093slop_ers
slotters84012403slotters
snorters83410583snorters
sorters74221133_sorters
souters74422603_souters
sporters103714063sporters
spotters104313383spotters
spouters104011163spouters
stopers94217373stop_ers
stoppers123910593stoppers
sumpters1238023sumpters
swotters11448483swotters
tempters12257293tempters
tilters73315953ti_lters
tinters74221113ti_nters
tippers113414353ti_ppers
tipplers12336353tipplers
tipsters10278523tipsters
titers64526413ti__ters
titters74219623ti_tters
tooters73818773_tooters
topers85025323_top_ers
toppers113914603_toppers
toters65026363_to_ters
totters74618733_totters
touters74018353_touters
trotters83310253trotters
violaters1245963violaters
vipers114914533vi_p_ers
visiters1137413visiters
voters95017443_vo_ters
whoppers18297533whoppers
winters103720483wi_nters
wipers115416083wi_p_ers
zippers203310383zi_ppers
zosters163015413_zosters

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 Filter1786911461620.436409841.7
2DLD Change Limit1461623276.55022314.8
3Display Results3273270.1402335.7
 (SQL Overall)1786913277.12625075.9
 
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.