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

265 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
scotties103973(None) 
scottie937441scottie_
catties94023052_catties
cooties93725732_cooties
cottier93814172_cottier
cottiers10399152_cottiers
cutties93118842_cutties
hotties103016952_hotties
plotties103111412plotties
potties93723542_potties
scanties103215412scanties
scattier10267582scattier
scattiest11268362scattiest
scotches15179472scotches
scotias939732sco_tias
scuttles1056502scuttles
shorties11414572shorties
snottier8217372snottier
snottiest9167962snottiest
softies103414612s_ofties
sorties74126402s_orties
spottier10207302spottier
spottiest11177682spottiest
aconites10314343aconites
acuities10312443acuities
agouties9337693agouties
biotites10310083biotites
blottier10336413blottier
blottiest11286833blottiest
booties94124613_booties
bothies12414783_bothies
bottles94216273_bottles
butties93217953_butties
cattie85221013_cattie_
cattier93317073_cattier
cattiest103016333_cattiest
chitties13310773chitties
cities84524853_c_ities
coatees93816533_coatees
coatis85122593_coati_s
cocottes1238303cocott_es
colies84837053_co_lies
collies94326583_collies
comities12317783_comities
commies133718443_commies
comtes106222813_comt_es
conies84338593_co_nies
contes84432913_cont_es
cookies133719273_cookies
coolies93824963_coolies
coonties10513793coonties
cootie84223073_cootie_
copies104130303_co_pies
corbies113520113_corbies
corries94026783_corries
cortices12615003_cortices
cortins92421313_cortins
cosies84932153_co_sies
coteries10422703_coteries
cotes76347843_co_t_es
cottae84615703_cottae_
cottages113310493_cottages
cottars94412233_cottars
cottas84615573_cott_as
cotter84926673_cott_er
cotters94323433_cotters
cottons9312193_cottons
cotypes1437943_cotypes
counties10316273_counties
cowpies143314283_cowpies
cowries124218013_cowries
cozies174521413_co_zies
cuties84927363_c_uties
cuttles93613923_cuttles
dacoities1248203dacoities
dhooties1237633dhooties
ditties83116983_ditties
dottier83910923_dottier
dottiest92611393_dottiest
dottles83912283_dottles
ecotages1136973ecotages
ecotones1039493ecotones
ecotypes1545053ecotypes
fatties103018203_fatties
footies103721543_footies
footsies1139643footsies
forties104323863_forties
glottides1163833glottides
glottis837163glotti_s
glottises1084953glottises
grottier9316673grottier
grottiest10147183grottiest
grottoes9276753grottoes
hogties112813993_hogties
hottie92514363_hottie_
jetties143613123_jetties
jutties143814003_jutties
kitties113213623_kitties
knottier12203983knottier
knottiest13174563knottiest
lottes65322753_lott_es
mottes85523693_mott_es
mottles93415803_mottles
mottoes93412193_mottoes
patties93425143_patties
plottier10327263plottier
plottiest11287833plottiest
posties93128813_posties
potpies113116173_potpies
potsies93019483_potsies
pottier93516493_pottier
pottiest102815973_pottiest
pottles93816983_pottles
pretties10615133pretties
prosties101421193prosties
putties94420023_putties
rottes64524833_rott_es
safeties1139163safeties
salties73725773s_alties
sanities81219753sanities
scabies11613333sc_abies
scampies1439323scampies
scantier10309983scantier
scantiest112611003scantiest
scathes124515713sc_athes
scatted103512773scatt_ed
scatter93815173scatt_er
scatters103612753scatters
scatting113311813scatting
scatts85914663scatt__s
sceptics1455663sceptics
sceptres1244993sceptres
schtiks16184743sc_htiks
sciatics12117273sciatics
scoleces1237073scoleces
scolices1238733scolices
sconces113811453sco_nces
scones84521303sco__nes
scooches15188413scooches
scootches1635003scootches
scooted103612273scoot_ed
scooter93312863scoot_er
scooters103511013scooters
scooting113012633scooting
scoots85315933scoot__s
scopes104719593sco__pes
scorches15189143scorches
scores84725923sco__res
scorifies1448013scorifies
scotched16187933scotched
scoter83815473sco_t_er
scoters93313793sco_ters
scotia8310783sco_ti_a
scotomas1256243scotomas
scotopias1345693scotopias
scots74025903sco_t__s
scourges1136533scourges
scouses93313243sco_uses
scouted104112033scout_ed
scouter93313323scout_er
scouters103411303scouters
scouther1356943scouther
scouthers1445993scouthers
scouths12527893scout_hs
scouting112612753scouting
scoutings12306143scoutings
scouts84817943scout__s
scrapies124612473scrapies
scries85226823sc__ries
scurries102911483scurries
scurvies13248123scurvies
scutages1136503scutages
scutches15168883scutches
scutes85219193sc_ut_es
scutter93512173scutt_er
scutters103311013scutters
scuttle936463scuttle_
scuttled1134533scuttled
scythes15356523sc_ythes
sentries81318053sentries
settees73513633s_ettees
settles73916003s_ettles
shanties113116573shanties
shelties111111373shelties
shittier1137303shittier
shittiest1238333shittiest
shittims1344403shittims
shoddies1336043shoddies
shortias1148073shortias
shortie10411323shortie_
shotes95321893sho_t_es
shotted113912383shott_ed
shotten10288443shott_en
shotting123012363shotting
shotts93614683shott__s
showtimes1743623showtimes
shuttles1136543shuttles
sixties14310973s_ixties
skittles1245763skittles
slittier837003slittier
slittiest938203slittiest
slotted84613873slott_ed
slotter73314443slott_er
slotters84012393slotters
slotting92612603slotting
sluttier836453sluttier
sluttiest937323sluttiest
smarties10312873smarties
smithies1337913smithies
smoothes13218533smoothes
smoothies1456123smoothies
smuttier1035213smuttier
smuttiest1135963smuttiest
snootier8278373snootier
snootiest9178743snootiest
snottily1145543snottily
snottiness1055593snottiness
snoutier8206973snoutier
snoutiest9178243snoutiest
societies1148803societies
soddies92312853s_oddies
softie93312473s_oftie_
somites94219113s_omites
sonnies7315223s_onnies
soothes103917103s_oothes
sootier73916603s_ootier
sootiest84016753s_ootiest
sophies12314603s_ophies
sopites93817173s_opites
sorites73825243s_orites
sortie63621983s_ortie_
sortied83314093s_ortied
sotted74121393s_ott_ed
sottish10129433s_ottish
spittles1038333spittles
spoonies101911753spoonies
sportier102010053sportier
sportiest111711023sportiest
spotted103713133spott_ed
spotter94514873spott_er
spotters104313373spotters
spottily1335143spottily
spottiness1285763spottiness
spotting112812083spotting
sties55132983s___ties
stithies1139233stithies
stogies8413693sto_gies
stoolies8311083stoolies
stories7324273sto_ries
stotins73213863sto_tins
stotted83511413stott_ed
stotting92811153stotting
stotts64612853stott__s
sureties8316583sureties
suttees74114063s_uttees
sweeties11159723sweeties
swotted11398703swott_ed
swotter10399463swott_er
swotters11448473swotters
swotting12268473swotting
tatties74120343_tatties
titties73617363_titties
tootsies848613tootsies
tutties73216473_tutties
zloties1639913zlo_ties

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.1701051123.5
2DLD Change Limit1461622657.37619815.9
3Display Results2652650.1102409.1
 (SQL Overall)1786912657.65623340.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.