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

196 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
drowsier128490(None) 
drossier956311drossier
frowsier1444891frowsier
blowsier1335062blowsier
brownier13226912brownier
browser124911142brows_er
crosier94116572cro_sier
dossier83711692d_ossier
dowdier12328572d_owdier
downier11299702d_ownier
dowser104716082d_ows_er
drawlier12225252drawlier
dressier956862dressier
droolier936072droolier
droopier1145572droopier
dropsied1234962dropsied
dropsies1138692dropsies
drowner11369802drow_ner
drowse105010552drows_e_
drowsed12448742drows_ed
drowses114610232drows_es
drowsiest1334992drowsiest
drowsily1583722drowsily
drowsing13287772drowsing
frowstier1553142frowstier
frowzier2343312frowzier
growlier1234882growlier
prosier93817482pro_sier
rosier64221262_ro_sier
rowdier11348592_rowdier
arouser74514423arous_er
artsier768943ar_tsier
blousier1055663blousier
blowier1248943blow_ier
blowzier2233413blowzier
bossier93712423_bossier
brasier94516753br_asier
brassier103310533brassier
brawlier13267043brawlier
brawnier13216723brawnier
bronzier1935633bronzier
broodier1157433broodier
broomier1236873broomier
browner124911643brow_ner
brownie12178433brownie_
brownies13189613brownies
browse115713853brows_e_
browsed134511233brows_ed
browsers13449193brows_ers
browses124712693brows_es
browsing14319353browsing
choosier1337163choosier
cosier84423753_co_sier
cowier113616163_cow_ier
crawlier13216873crawlier
creasier103210193creasier
croakier14436263croakier
crosiers103312053cro_siers
crosser95015463cro_sser
croupier1246883croupier
crowder13389843crow_der
crowdie1335903crowdie_
crowdies1437543crowdies
crower114117553crow__er
crowner124012593crow_ner
crowstep1543333crowstep
crozier18369933cro_zier
dewier104013463d_ew_ier
ditsier83010293d_itsier
dodgier10388243d_odgier
doggier103810943d_oggier
donsie7613643d_onsie_
doomier103610123d_oomier
doomster1135843doomster
dopier93515923d_o_pier
dorkier122810023d_orkier
dorser74819173d_ors_er
doser66228563d_o_s_er
dosser74417973d_o_sser
dossiers9318043d_ossiers
dotier73917033d_o_tier
dottier83910923d_ottier
douser75621633d_ous_er
dowager1245803d_owager
dowdies123412733d_owdies
dower95027703d_ow__er
dowie94721143d_ow_ie_
downer104414923d_ow_ner
dowries114413983d_owries
dowse96020813d_ows_e_
dowsed115015013d_ows_ed
dowsers115013523d_ows_ers
dowses105718303d_ows_es
dowsing123411123d_owsing
dozier163611633d_o_zier
draffier1574323draffier
draftier1285263draftier
draggier11135763draggier
dragster1034623dragster
drawer104711363draw__er
drawler11338593draw_ler
dreamier11287293dreamier
drearier9297923drearier
dreggier1193553dreggier
dresser83611953dr_esser
drier64423963dr___ier
driftier1275123driftier
drippier1385043drippier
droller84110283dro_ller
droner74717673dro__ner
dropper12329873dro_pper
drosera836203dro_s_era
droskies13186343droskies
drosses84513823dro_sses
drossiest1036523drossiest
drouthier1343033drouthier
drover104614593dro__ver
drownded14334433drownded
drowned12419903drow_ned
drowners12428273drow_ners
drowning13298363drowning
drowsiness1443643drowsiness
drowsy13487903drows__y
druggier11134833druggier
drumlier1134523drumlier
flossier11326973flossier
froggier1354643froggier
frontier1147313frontier
frostier1148163frostier
frothier1435953frothier
frouzier2043703frouzier
frowner13429683frow_ner
frowsiest1535063frowsiest
frowsted1534313frowsted
glossier9358203glossier
goosier83512563_goosier
gorsier83811073_gorsier
grassier9349283grassier
greasier9298083greasier
grodier939673gro_dier
groggier1134343groggier
groovier1233793groovier
grosser84313143gro_sser
grottier9316673grottier
grouser84513693grous_er
groutier9297173groutier
grower104614933grow__er
growler11318973grow_ler
growthier1642203growthier
horsier103013243_horsier
hosier94219613_ho_sier
jowlier17327563_jowlier
lousier72411623_lousier
lowlier10338903_lowlier
mossier94413813_mossier
mousier93712463_mousier
newsier10147223_newsier
noisier759453_noisier
nosier63716323_no_sier
osier53518013__o_sier
prissier10157873prissier
promiser122510673promiser
proser84223463pro_s_er
prosper114012183pro_sper
prossie91812953prossie_
prossies101515223prossies
prower114218123prow__er
prowler123310013prow_ler
roaster74116663_roaster
rockier134911883_rockier
roilier7311523_roilier
roister73516203_roister
rookier114012383_rookier
roomier93812243_roomier
rooser63921883_roos_er
rooster74415173_rooster
rootier74915393_rootier
ropier84118803_ro_pier
roster64329083_ro_ster
roupier9319493_roupier
rouser65224083_rous_er
rouster73517083_rouster
rowdies113112693_rowdies
rower85430493_row__er
royster103110533_royster
showier1339093show_ier
snowier1038783snow_ier
sonsier7711743_sonsier
throwster1542953throwster
tressier847963tressier
trouser73812463trous_er
troutier8277143troutier
troweler11106063troweler
trowsers11427983trows_ers
woodsier1245473woodsier
wowser125110203_wows_er

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.186960704.3
2DLD Change Limit1461621967.66019081.2
3Display Results1961960.0603266.7
 (SQL Overall)1786911967.90622601.9
 
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.