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

195 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
frowsier144489(None) 
drowsier1284901drowsier
frowstier1553141frowstier
frowzier2343311frowzier
blowsier1335062blowsier
brownier13226912brownier
browser124911142brows_er
crosier94116572cro_sier
drossier956312drossier
flossier11326972flossier
froggier1354642froggier
frontier1147312frontier
frostier1148162frostier
frothier1435952frothier
frouzier2043702frouzier
frowner13429682frow_ner
frowsiest1535062frowsiest
frowsted1534312frowsted
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
dossier83711693_dossier
dowdier12328573_dowdier
downier11299703_downier
dowser104716083_dows_er
drawlier12225253drawlier
dressier956863dressier
droolier936073droolier
droopier1145573droopier
dropsied1234963dropsied
dropsies1138693dropsies
drowner11369803drow_ner
drowse105010553drows_e_
drowsed12448743drows_ed
drowses114610233drows_es
drowsiest1334993drowsiest
drowsily1583723drowsily
drowsing13287773drowsing
fawnier13296363f_awnier
flawier13378733flaw_ier
flimsier1344133flimsier
floatier1136983floatier
flockier1745343flockier
floosie10378933floosie_
floosies113210233floosies
floppier1554633floppier
flosser10339693flo_sser
flossie10337443flossie_
flossies112810123flossies
flower124815503flow__er
flowerer1435453flowerer
flowerier1544273flowerier
foamier12339003f_oamier
foggier12349913f_oggier
folkier14359043f_olkier
folksier1533533folksier
footier104115113f_ootier
footsie1047643footsie_
footsies1139643footsies
foreseer1139013foreseer
forester11313673forester
forkier144311583f_orkier
foster94322223f_o_ster
fowler123712583f_ow_ler
foxier163910033f_o_xier
fozier183710663f_o_zier
freakier15246483freakier
fresher132612643fr_esher
frettier1156593frettier
frier85225843fr___ier
frillier1136513frillier
fringier1236543fringier
frisker14389273fr_isker
friskier1535193friskier
frizzier19284813frizzier
fronter103611583fro_nter
frontiers1254993frontiers
frosted113211873fro_sted
frother133110153fro_ther
frowned14348833frow_ned
frowners14377933frow_ners
frowning15307833frowning
frows116623103frows___
frowst125512073frows__t
frowstiest1643083frowstiest
frowsting1634683frowsting
frowsts13426093frows_ts
frowsty16464983frows_ty
frowsy15498273frows__y
frowziest2443483frowziest
frowzily2642673frowzily
fruitier1136583fruitier
frumpier1534173frumpier
fubsier12367763f_ubsier
fussier103610673f_ussier
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 10 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.1731032896.0
2DLD Change Limit1461621959.00016240.2
3Display Results1951950.0762565.8
 (SQL Overall)1786911959.24919320.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.