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

139 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
frowzier234331(None) 
frouzier2043701frouzier
frowsier1444891frowsier
blowzier2233412blowzier
bronzier1935632bronzier
brownier13226912brownier
crozier18369932cro_zier
drowsier1284902drowsier
fozier183710662f_o_zier
frizzier19284812frizzier
froggier1354642froggier
frontier1147312frontier
frostier1148162frostier
frothier1435952frothier
frowner13429682frow_ner
frowstier1553142frowstier
frowziest2443482frowziest
frowzily2642672frowzily
growlier1234882growlier
rowdier11348592_rowdier
blowier1248943blow_ier
blowsier1335063blowsier
boozier18349013_boozier
brawlier13267043brawlier
brawnier13216723brawnier
brazier183911473br_azier
breezier1934533breezier
bronzer18348493bronz_er
broodier1157433broodier
broomier1236873broomier
browner124911643brow_ner
brownie12178433brownie_
brownies13189613brownies
browser124911143brow_ser
cowier113616163_cow_ier
cozier173315143_co_zier
crawlier13216873crawlier
crazier183610743cr_azier
croakier14436263croakier
crosier94116573cro_sier
croupier1246883croupier
crowder13389863crow_der
crowdie1335913crowdie_
crowdies1437553crowdies
crower114117563crow__er
crowner124012603crow_ner
crozer175112843cro_z_er
croziers19287003cro_ziers
dowdier12328573_dowdier
downier11299703_downier
dozier163611633_do_zier
drawlier12225253drawlier
droolier936073droolier
droopier1145573droopier
drossier956313drossier
drowner11369803drow_ner
fawnier13296363f_awnier
fizzier18326713f_izzier
flawier13378733flaw_ier
floatier1136983floatier
flockier1745343flockier
floozie19295463floozie_
floozies20326953floozies
floppier1554633floppier
flossier11326973flossier
flower124815503flow__er
flowerer1435453flowerer
flowerier1544273flowerier
foamier12339003f_oamier
foggier12349913f_oggier
folkier14359043f_olkier
footier104115113f_ootier
foozler19397593f_oozler
forkier144311593f_orkier
fowler123712583f_ow_ler
foxier163910033f_o_xier
freakier15246483freakier
freezer19348523freez_er
frenzied2144043frenzied
frenzies2037713frenzies
frettier1156593frettier
frier85225843fr___ier
frillier1136513frillier
fringier1236553fringier
friskier1535193friskier
frizer184011283fr_iz_er
frizzer18446893fr_izzer
frizzies19315933frizzies
frizzler19345843frizzler
frizzlier20122883frizzlier
fronter103611583fro_nter
frontiers1254993frontiers
frother133110153fro_ther
frouziest2143973frouziest
frowned14348833frow_ned
frowners14377933frow_ners
frowning15307833frowning
frowsiest1535063frowsiest
frowsted1534313frowsted
frowzy24485793frowz__y
froze174515653fro_z_e_
frozen18408443fro_z_en
fruitier1136593fruitier
frumpier1534173frumpier
furzier19318103f_urzier
fuzzier18256523f_uzzier
grazier173611133gr_azier
grodier939673gro_dier
groggier1134343groggier
groovier1233793groovier
grottier9316673grottier
groutier9297173groutier
grower104614933grow__er
growler11318973grow_ler
growthier1642203growthier
jowlier17327563_jowlier
lowlier10338903_lowlier
oozier153610253__oozier
prosier93817483pro_sier
prower114218123prow__er
prowler123310013prow_ler
ritzier16297203_ritzier
rockier134911883_rockier
roilier7311523_roilier
rookier114012383_rookier
roomier93812243_roomier
rootier74915393_rootier
ropier84118803_ro_pier
rosier64221263_ro_sier
roupier9319493_roupier
rowdies113112693_rowdies
rower85430493_row__er
rozzer1437353_ro_zzer
showier1339103show_ier
snoozier17185193snoozier
snowier1038793snow_ier
troutier8277153troutier
troweler11106063troweler
woozier19347323_woozier

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.420425454.8
2DLD Change Limit1461621396.78321548.3
3Display Results1391390.0463021.7
 (SQL Overall)1786911397.24924650.4
 
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.